Re: Week Numbers for Tax Year
- From: "mlv" <mike.safetycatchvincent@xxxxxxxxx>
- Date: Mon, 11 Jun 2007 11:38:56 +0100
Rick Rothstein wrote:
Alright, so I am confused now.<g> Can you spell out what criteria you want
to govern when Tax Week 1 occurs (in general, not for just this year)? It
looks like you (well, I should say you client) wants it to be the full
calendar week that contains April 1st (not April 6th)... is that correct?
What does your client consider a calendar week... Sunday to Saturday or
Monday to Sunday? Does the ISO Thursday Rule factor into the week
numbering when using the April 1st Rule that your client appears to use?
You're confused? Me too! :-)
Today I spoke with my client who insisted they use Tax Year week numbers to
the IR rules.
They then came back to me to say they got it wrong this year and had week 1
(2007-08), where they should have had week 53 (2006-07). They assure me
they will get it right next year!
I shall simply use the IR Tax Year week formula with a +1 correction for
this year and next year the unaltered formula should be fine.
Thanks to you and everyone else for the useful input.
--
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\)
- Re: Week Numbers for Tax Year
- From: Roger Govier
- Re: Week Numbers for Tax Year
- From: mlv
- Re: Week Numbers for Tax Year
- From: Roger Govier
- Re: Week Numbers for Tax Year
- From: mlv
- Re: Week Numbers for Tax Year
- From: Rick Rothstein \(MVP - VB\)
- Week Numbers for Tax Year
- Prev by Date: Re: Setting Location of Query
- Next by Date: Re: Using AutoFilter
- Previous by thread: Re: Week Numbers for Tax Year
- Next by thread: Re: Week Numbers for Tax Year
- Index(es):
Relevant Pages
|