Autoincrementing dates
 

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.

Autoincrementing dates
 

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"
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.

Autoincrementing dates
 

Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk
:
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...

Autoincrementing dates
 

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

Autoincrementing dates
 

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
:
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...

Autoincrementing dates
 

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

Regards,

Andrew

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