Re: Week Numbers for Tax Year

Roger Govier wrote:

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



Rick Rothstein wrote:

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

For today's date (7 June 2007) both of the above formulas give the answer 9.

However, I calculate that this week is at least UK Tax Year Week No. 10, or
possibly 11.
--
Mike
-Please remove 'safetycatch' from email address before firing off your
reply-


.