Week Number required starting from April (Week 1 should be the first week of April)

[excel_learner]

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.

[#2 · Accepted solution]

@excel_learner 

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.