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.

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.

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.

What do you want to use?

When do you want the new date to appear?

--
Regards,
Tom Ogilvy

"John" <John@discussions.microsoft.com> wrote in message
news:27027B52-F66B-4E35-B37D-268D5311D4E1@microsoft.com...
> 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.

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" <John@discussions.microsoft.com> wrote in message
news:27027B52-F66B-4E35-B37D-268D5311D4E1@microsoft.com...
> 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.