I'd like to have a column that displays incremental month and year (no
day).

How do I do this?

There is a list of possible date formats in format cells under number-date
(right click to get to format cells). Simply select the one without the day.
:)
--
-SA


"Howard Brazee" wrote:

I'd like to have a column that displays incremental month and year (no
day).

How do I do this?

On Thu, 17 Jul 2008 14:01:04 -0700, StumpedAgain
wrote:

There is a list of possible date formats in format cells under number-date
(right click to get to format cells). Simply select the one without the day.
:)

I did right click it and didn't see what I was looking for. Maybe
it's because I'm using Excel 2003.

On Thu, 17 Jul 2008 17:09:26 -0700, "CLR"
wrote:

With your first date in A1, put this in A2 and copy down.......

=TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"MMMM YYYY")

Thanks, that worked nicely.

With your first date in A1, put this in A2 and copy down.......

=TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"MMMM YYYY")

Vaya con Dios,
Chuck, CABGx3


"Howard Brazee" wrote in message
...
I'd like to have a column that displays incremental month and year (no
day).

How do I do this?

You're welcome Howard.......thanks for the feedback.......

And, BTW, you might check your System Clock......from the time of your post,
it appears to be slow.

Vaya con Dios,
Chuck, CABGx3


"Howard Brazee" wrote in message
...
On Thu, 17 Jul 2008 17:09:26 -0700, "CLR"
wrote:

With your first date in A1, put this in A2 and copy down.......

=TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"MMMM YYYY")

Thanks, that worked nicely.

On Fri, 18 Jul 2008 17:11:56 -0700, "CLR"
wrote:

And, BTW, you might check your System Clock......from the time of your post,
it appears to be slow.

It looks right from here. Where in the newsgroup process does that
time get posted?