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