WEEKNUM Function

  • Thread starter Thread starter Trevor Aiston
  • Start date Start date
T

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
 
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
 
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)
 
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
 
Back
Top