How to calculate weeknumber for a financial year

Otman

Hi,

I need to calculate the week number of dates according to a fiscal year starting April first 2024 and ending 31 March 2025.

THe formula weeknumber gives me the week numbers based on a year starting from January First and ending 31 December 2024.

Thank you for your help

Michelle Rogers

Try something like this…

=IF((WEEKNUMBER([Week Start Date]@row) - 13) <= 0, WEEKNUMBER([Week Start Date]@row) + 39, WEEKNUMBER([Week Start Date]@row) - 13)

I found this post to be quite helpful when figuring this out for my company. @Toufong Vang provided an excellent answer to the post below with how to adjust calculations based on your specific starting date.

https://community.smartsheet.com/discussion/92903/fiscal-year-week-number

Let me know if this helps you!