Re: Week Numbers for Tax Year

From: "Rick Rothstein \(MVP - VB\)" <rickNOSPAMnews@xxxxxxxxxxxxxxxxx>
Date: Wed, 6 Jun 2007 17:36:03 -0400

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

.

Follow-Ups:
- Re: Week Numbers for Tax Year
  - From: Roger Govier
- Re: Week Numbers for Tax Year
  - From: mlv

References:
- Week Numbers for Tax Year
  - From: mlv

Prev by Date: macro query disable download failure
Next by Date: Size of Chart-Save as Web Page
Previous by thread: Re: Week Numbers for Tax Year
Next by thread: Re: Week Numbers for Tax Year
Index(es):
- Date
- Thread