I have a column formatted as "Date" with format March-01, etc.

If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
A1+1 but the syntax is not understood by Excel 2003.

Many thanks.

In A1 enter Jan-08 and drag till u want

it will show only Jan-08, at the end of the cursor u will autofill
option click for more option and then choose fill months

u will get the result as u need......




On Apr 6, 10:16*am, "Andrew Chalk" <ach...@magnacartasoftware.com>
wrote:
> I have a column formatted as "Date" with format March-01, etc.
>
> If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
> A1+1 but the syntax is not understood by Excel 2003.
>
> Many thanks.

Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk
<(E-Mail Removed)>:
> I have a column formatted as "Date" with format March-01, etc.
>
> If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
> A1+1 but the syntax is not understood by Excel 2003.

There are many ways, and this may or may not be the simplest, but I
have just tested it and I know it works:

1. Enter 1-1 in A1. (Excel will convert that to some form of 1
January 2008.)

2. Enter =DATE(YEAR(A1),MONTH(A1)+1,1) in A2.

3. Highlight both cells and custom format as mmm-yy.

4. Hightlight A2 only, and use the fiull handle to drag down the
desired number of months. Both the formula and the format will
propagagte.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

Hi Andrew,

Right Click on the fill handle and drag down as far as
you need when you let go of the right button at the
bottom you will be given a Menu of options.
Left click on the one you want which in this case
will be Fill Months.

HTH
Martin


"Andrew Chalk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a column formatted as "Date" with format March-01, etc.
>
> If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
> A1+1 but the syntax is not understood by Excel 2003.
>
> Many thanks.
>

Hi,

There are a couple of other ways that are quite good to use as well:

=EDATE(A1,1)
=EOMONTH(A19,0)+1

edate gives you the next month and eodate gives you the last day of the
month (0=current) and then you add one to get the first day of the next month.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Stan Brown" wrote:

> Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk
> <(E-Mail Removed)>:
> > I have a column formatted as "Date" with format March-01, etc.
> >
> > If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
> > A1+1 but the syntax is not understood by Excel 2003.
>
> There are many ways, and this may or may not be the simplest, but I
> have just tested it and I know it works:
>
> 1. Enter 1-1 in A1. (Excel will convert that to some form of 1
> January 2008.)
>
> 2. Enter =DATE(YEAR(A1),MONTH(A1)+1,1) in A2.
>
> 3. Highlight both cells and custom format as mmm-yy.
>
> 4. Hightlight A2 only, and use the fiull handle to drag down the
> desired number of months. Both the formula and the format will
> propagagte.
>
> --
> Stan Brown, Oak Road Systems, Tompkins County, New York, USA
> http://OakRoadSystems.com
> Shikata ga nai...
>

Thanks everyone for your help. All of these methods seem to work.

Regards,

Andrew

"Andrew Chalk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a column formatted as "Date" with format March-01, etc.
>
> If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
> A1+1 but the syntax is not understood by Excel 2003.
>
> Many thanks.
>