WEEKNUM Function

[Trevor Aiston]

Is there a switch I can use with weeknum function that will calculate week
numbers based on UK tax year rather than calender year?

TIA

Trevor

 

[Guest]

Try: =INT((A1-DATE(YEAR(A1)-(TEXT(A1,"mdd")+0<406),3,30))/7)

Where A1 houses the date you want to return the weeknum for.

Regards
Jon von der Heyden

 

[Bob Phillips]

I don't think it is straight-forward, a the tax year starts on 5th April,
which could be any day of the week, whereas WEEKNUM functions are based upon
a week starting on a particular day.

If the week number is solely based upon the start date, then use

=INT((target_date-tax_year_start_date)/7)+1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

Try: =INT((A1-DATE(YEAR(A1)-(TEXT(A1,"mdd")+0<406),3,30))/7)

Where A1 houses the date you want to return the week num for.

Regards
Jon von der Heyden