Re: Week Numbers for Tax Year

From: "mlv" <mike.safetycatchvincent@xxxxxxxxx>
Date: Thu, 7 Jun 2007 09:55:47 +0100

Rick Rothstein wrote:

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

Thanks for all your help Rick - I'll give the formulas a thorough testing.
--
Mike
-Please remove 'safetycatch' from email address before firing off your
reply-

.

References:
- Week Numbers for Tax Year
  - From: mlv
- Re: Week Numbers for Tax Year
  - From: Rick Rothstein \(MVP - VB\)

Prev by Date: Re: Sum values that precede todays date
Next by Date: Re: How to find if the cell is emty or contains value
Previous by thread: Re: Week Numbers for Tax Year
Next by thread: Re: Week Numbers for Tax Year
Index(es):
- Date
- Thread