Re: Week Numbers for Tax Year

Hi Rick

With your formula, you get negative week numbers once you get past
December of the year, gradually reducing from -65 to -52.

I think the formula is nothing more complicated than
=INT((A1-DATE(2007,4,6))/7)+1
This will give week 52 for 29 March 2008, and week 53 for 04 April 2008
This is (I believe) correct but the OP must confirm with Inland Revenue,
as we do have a 53 week year from time to time.
It all depends upon which day of the week the Payroll is calculated
Most years are 52 week years, but periodically there will be a 53 week
year and the tax tables or calculations in the UK are based upon this
fact.
--
Regards

Roger Govier


"Rick Rothstein (MVP - VB)" <rickNOSPAMnews@xxxxxxxxxxxxxxxxx> wrote in
message news:u5SC6KIqHHA.3892@xxxxxxxxxxxxxxxxxxxxxxx
Can anyone post a reliable formula for calculating week numbers
in Excel that relate to the UK Tax year?

You can read my discussions in my other posts, but since you
specifically asked for a "formula", I presume you want a work***
formula. So, here is my TaxWeekNumber macro function translated into a
work*** formula.

=INT((DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))-DATE(YEAR(A1) + (32 *
MONTH(A1) + DAY(A1) < 134), 3, 6))/7)+1

Same cautions exist as mentioned in my other postings, so make sure
you give it a good testing out before putting it to use.

Rick


.