how do i do this
 

On Thu, 12 Jan 2006 07:17:01 -0800, in
microsoft.public.excel.worksheet.functions you wrote:

i'm not sure i understand your logic
a +1 increments my date by one (1) DAY
adding +30 increments by 30 days which doesn't quite work because of
months ending in 28,30 and 31 days

what i am really after is something will change

1/3/06 to 2/3/06
1/10/06 to 2/10/06
etc

or are we looking at a date format of dd mm yyyy


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

how do i do this
 

=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))

HTH
Kostis Vezerides