Create a formula to fill in a date series without using
 

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.

Create a formula to fill in a date series without using
 

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

"John" wrote:

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.

Create a formula to fill in a date series without using
 

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

"Vacation's Over" wrote:

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

"John" wrote:

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.

Create a formula to fill in a date series without using
 

What do you want to use?

When do you want the new date to appear?

--
Regards,
Tom Ogilvy

"John" wrote in message
...
I was wanting to have the months fill in without having to use the fill
handle.

"Vacation's Over" wrote:

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

"John" wrote:

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.

Create a formula to fill in a date series without using
 

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.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
I was wanting to have the months fill in without having to use the fill
handle.

"Vacation's Over" wrote:

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

"John" wrote:

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.