dates, 1st of month

[LatinViolin]

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.

 

[JE McGimpsey]

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)

 

[LatinViolin]

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

 

[Tom Ogilvy]

Did you put the formula in A2. Is the value in A1 an actual Date value
1-Jan-2005

i.e. if you format A1 as general does it look like: 38353


Actually, the formula works for me even with the string 1-Jan-2005 in A1.
If I make A1 blank, I get #Value, not #Num. I can get a #Num if I put a
negative number in A1