>The standard way to solve such puzzles is to have Calendar and Numbers tables in the database. If you have such tables, then the solution becomes trivial
>

I've been slapping my head after reading the first set of responses - because I put a Date Dimension or even a basic date master (with date, weekend date, month, season definitions, etc.) in every database. Didn't occur to me to utilize it for this. (Slaps head)

Thanks everybody...