Create a formula to fill in a date series without using

[Guest]

I have a column that is just a series of dates. I want this column to
automatically fill in according to the first date entered in the column. It
needs progress one month at a time.

 

[Guest]

excel 2003

put in first date
select cell and use "fill handle' to copy down as many rows as you wish
when you release you should see an autofill options box appear at theend of
the column select fill months

 

[Guest]

I was wanting to have the months fill in without having to use the fill handle.

 

[Tom Ogilvy]

What do you want to use?

When do you want the new date to appear?

 

[Tom Ogilvy]

assume your date is in B1

in B2, put in

=DateSerial(Year(B1),Month(B1)+1,1)

then drag fill down the column - assume you don't mind filling the formula.

Putting all the information in the body of your email makes it easier to
understand what you want.