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

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

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

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

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

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