Retail months follow the same pattern with a fluctuation only once ever many
years (maybe 11).

Every third retail month has five weeks, the rest have four. The last day
of the current retail month is Oct 4 and this is a five week month.

With the rules it shouldn't be to hard to code.

Jesse Hamilton





"Matt." wrote in message
.. .
Hi all!

I've written a small application that grabs data from 6 different data
sources, and puts them all into Excel for graphing. I was asked to do
this
by Month. So I did. Calendar month. It now turns out that they meant
Fiscal Months. (i.e. October 2003 starts 2003/09/29 and ends 2003/10/26).

Is there anything out there allowing me define fiscal periods and then
compare a date against the definition?

cheers,
Matt.