Show ongoing week ranges in my report

Hannah Young

Hi there, 

I want to show the week on week closed project. 

I am trying to show week ranges, eg. APR 14-20, APR 21-27, APR 28-MAY 4 and so on in my report. 

And if the closed date is on Apr 16, it will fall under the Apr 14-20.

It is currently giving my Week Number such as 2025-W15, 2025-W16 and so on.

Is there a way in the settings to do this? Or custom formula in Visual mode. I am a beginner here, cannot do the sql mode.  I have a column for closed date named "Date Updated"

Thank you for those who will answer

 

Eugenio Onofre_v78igo

Hi @Hannah Young

Welcome to the Atlassian Community!

Unfortunately, most reporting tools (like Jira dashboards, JQL, or even some BI tools connected via Jira) default to ISO week numbers. 

There's no native setting to format week ranges like "Apr 14–20" — it sticks to week numbers. For more flexibility, please see 3 options below:

1. Use Google Sheets or Excel + Jira Export
   1. Export your Jira issues
   2. Use formulas as =TEXT(A2, "mmm d") & "–" & TEXT(A2+6, "mmm d")
   3. Use this to create a pivot table showing tickets closed per week range.
2. Use eazyBI (if available)
3. Use Custom Fields (Workaround)
   1. Create a custom "Week Label" field
   2. Use Automation for Jira to populate it based on the updatedDate falling into a week range (E.g., “Apr 14–20”, “Apr 21–27”, etc.)
   3. Then group by that custom field in your reports

Please remember to vote and accept this answer in case it helps you resolve your query.

Regards,
Eugenio