Month and Year in Excel 2003

[Howard Brazee]

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

How do I do this?

 

[StumpedAgain]

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.

 

[Howard Brazee]

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.

 

[Howard Brazee]

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.

 

[CLR]

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

 

[CLR]

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]

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?