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
Answers
-
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.
Let me know if this helps you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!