Company with different calendar year

[mlbrenes]

Hi everyone,

I've been looking for a solution but haven't been able to find one! I hope you can help!

My issue is that my company has a different calendar year, it starts in April and ends in March, I want to use the formula to get the Week Number however a simple WEEKNUM() is not useful in my case, any ideas???

Thanks!

 

[wideboydixon]

With the date in A1, try this in B1:

=INT((A1-DATE(2017,4,1))/7)

WBD

 

[mlbrenes]

With the date in A1, try this in B1:

=INT((A1-DATE(2017,4,1))/7)

WBD

Amazing!

Thank you!!