Rick,
Fantanstic, it works well.
Happy new year!
--
capt


"Rick Rothstein (MVP - VB)" wrote:

Put this formula...

=DATE(YEAR(NOW())-(MONTH(NOW())<ROWS($1:1)),ROWS($1:1),1)

in the cell where your January date is supposed to be, copy it down through
the next 11 cells and, finally, apply the Mar-01 date format from the Format
Cells option to those 12 cells.

Rick


"capt" wrote in message
...
Thanks Gary,
The trouble its changing every date at once. Is there a way in order that
the year changes when the month actually starts. In other words: because
we
are in the month of January cell A2 changes to Jan 08 the rest remain
indicating 07 year. Then as we reach the end of Jan and go into Febuary
then
it changes to Feb 08 and it carrys on changing as we reach that month for
real.
I hope that makes sense?
--
capt


"Gary''s Student" wrote:

Here is an example of monthly updating:

In A1 enter:
39083

In A2 enter:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) and copy this formula down as far as
you like.

Select column A and:

Format Cells... Number Custom mmm-yy
--
Gary''s Student - gsnu200762


"capt" wrote:

I have the following table:

Jan-08
Feb-07
Mar-07
Apr-07
May-07
Jun-07
Jul-07
Aug-07
Sep-07
Oct-07
Nov-07
Dec-07

Is there a formula that when we enter a new month, in this case Feb 07
it
will change to Feb 08 and as we enter the following month in turn it up
dates
to 08 each time?
--
capt