Autoincrementing dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Chalk - 06 Apr 2008 06:16 GMT

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.

Reply to this Message

muddan madhu - 06 Apr 2008 07:15 GMT

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.

Reply to this Message

Stan Brown - 06 Apr 2008 08:01 GMT

Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk
<achalk@magnacartasoftware.com>:

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

Signature

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

Reply to this Message

Martin Fishlock - 06 Apr 2008 16:01 GMT

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.

Signature

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

> Sun, 6 Apr 2008 00:16:31 -0500 from Andrew Chalk
> <achalk@magnacartasoftware.com>:
[quoted text clipped - 16 lines]
> desired number of months. Both the formula and the format will
> propagagte.

Reply to this Message

MartinW - 06 Apr 2008 08:37 GMT

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

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

Reply to this Message

Andrew Chalk - 06 Apr 2008 17:02 GMT

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

Regards,

Andrew

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

Reply to this Message