Week number for Financial year 1/07/2018 to 30/06/2019

[everblazing]

Hi

In column A I have dates, in column B i am trying to find the week number for that date. I am referring to the date as the Australian financial year. Considering the 1st of July is the start of year. so if cell A10 is 9/07/2018, In B10 i should have 2.

I appreciate any assistance.

Regards
Lucas

 

[fhqwgads]

try this formula in B2

=IF(DATE(0,MONTH(A10),DAY(A10))<183,QUOTIENT((A10-DATE(YEAR(A10)-1,7,1)+7),7),QUOTIENT((A10-DATE(YEAR(A10),7,1)+7),7))

hope that worked

edit: i meant cell B10, not B2

 

[Fazza]

or

=INT((A10-DATE(2018,7,1))/7)+1