No thats fine Rick, your first code will do nicely.
Thank very much.
--
capt


"Rick Rothstein (MVP - VB)" wrote:

No, it will not. When the date is January 1, 2009 is when the Jan-08 will
change. Were you after some other functionality?

Here is a formula that will show you how the display will look for various
dates. Put this in some cell (other than C1) and copy down...

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

Just type various dates into C1 and watch how the display changes for them.
If you need a different type of display, just let us know.

Rick


"capt" wrote in message
...
Just one more question Rick,
When I reach Dec-08, will Jan-08, at the top of the list, change to Jan-09
or do I have to continue with the list down as far as I wish?
--
capt


"capt" wrote:

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