Yes, it can cross into year boundaries. To provide further detail, I am
trying to add this additional code into an existing macro to handle some
additional formatting of a report that could be run every month. Apologies
for not adding these further details earlier.

"MerleSmith" wrote:

Do you cross year boundaries? e.g. startdate of FEB-2008, which would cross
back into 2007. This makes the problem a little more complex.
--
Merle


"MattyO" wrote:

I want to take/copy/whatever? the date from a particular cell in the format
DD-MMM-YYYY, from there I want to format that date into MMM-YY into another
cell. After that has been complete, take that formatted date and auto fill 6
more columns with the past 6 months.

Another way to look at it:

(Take Cell A1) 18-JUN-2008 (Format Cell D1 like this) JUN-2008 (Then
auto fill F1:L1)JUN-2008 to JAN-2008

Please help.