Autoincrementing dates

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

Many thanks.

 

[muddan madhu]

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

 

[Stan Brown]

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.

 

[MartinW]

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

 

[Martin Fishlock]

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.

 

[Andrew Chalk]

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

Regards,

Andrew