Put

1-feb-2005

in A2, then select A1:A2 and drag the fill handle down as far as
necessary.

If you must have a function, one way:

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


In article ,
"LatinViolin" wrote:

in cell A1 i have 1-jan-2005. i would like to copy this info down into A2,
A3, A4, etc. as long as i like but each cell should read the next month 1st
day. example:

A1 = 1-jan-2005
A2 = 1-feb-2005
A3 = 1-mar-2005
etc.

what formula do i put in A2 and copy it down such each cell below A2 will
come out with the 1st of the month and change years when necessary?

please help.