re: how do i do this

[[email protected]]

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
> >
> >
> >
> >
> > "[email protected]" 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
> > >
> > >

[vezerid]

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

HTH
Kostis Vezerides