Forum Discussion
Solved
Week Number required starting from April (Week 1 should be the first week of April)
How would i get a Week number based on a date, with week 1 being the 1st week of April instead of 1st week of January.
If you want to use something resembling the US numbering system (Week 1 starts on April 1, each Sunday starts a new week):
With a date in A2, the week number is returned by =WEEKNUM(A2-91)
This can be filled down.
If you want to use something resembling the US numbering system (Week 1 starts on April 1, each Sunday starts a new week):
With a date in A2, the week number is returned by =WEEKNUM(A2-91)
This can be filled down.
