dates, 1st of month
 

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.

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.

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.

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



--
Regards,
Tom Ogilvy

"LatinViolin" wrote in message
...
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.