Does your week always start on the same day? If so then you can wind up
with a year falling into 54 actual weeks. I have a routine which calculates
the fiscal week of the year based on a Monday week start. Corrects for leap
years, change of century, etc, etc. A rule is imposed which causes Jan 1 to
always occur in week 1 of the current year so that some December dates are
included in week 1 whenever Jan 1 is not on a Monday. Contact me privately
if this would be of interest.
========================================
At 01:42 PM 10/11/2001 -0400, you wrote:
>I've been asked to produce a report on an ongoing basis that reports, by
>week for a given month, certain productivity stats.
>
>The weekly part has me stumped. The best I can think of is an
>annually-updated 52 row table, but the "annually-updated" is a flop waiting
>to happen.
>
>Can I say logically that a given date falls in week (n) in any given year?
>
>tia
>
>Dave
>
>
