thanks, the pull-down worked, but the formula, which is what i need, gives me
#num!. can you help?

"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.