In the top cell of your DATE column, type in the first date of the range of
interest, such as 1/1/2005...........then, assuming that is in cell A5, in
the cell just below it, put =A5+1, and copy the formula down as far as you
want. Then, whenever you change the date in A5, the other cells will
automatically follow..........

hth
Vaya con Dios,
Chuck, CABGx3




" wrote:

col a (a7:a64) contains dates for the current month with data in
subsequent columns

data is pretty static (repetitious) from month to month

at the end of each month i copy the current w/s to a new w/s (not w/b)
is there an easy way just to change just the month in column a

1/15/06 becomes 2/15/06

thanks