How to calculate weeknumber for a financial year



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!