Month mmmm format

[Steve McBride]

I was setting up a calendar in Excel, and in Cell A1 had a manually entered
date of 10/1/03.

In cell C1, I entered the formula =MONTH(A1), which naturally returned a
"10".

I then formatted cell C1 as Custom: mmmm and was very surprised to see it
return January when I expected it to return October (10th month).

I tried to Google this, and I also went to Chip Pearson's website, but
either I am searching on the wrong key words, or it hasn't been addressed.

Is there anyone out there who can explain why it didn't work?

I did create a lookup table to get around the issue, and that works okay,
but it seems like work that should have been unnecessary.

TIA,
Steve

 

[Arvi Laanemets]

Hi

C1=A1, and format as "mmmm"
You formatted the number 10 as "mmmm". The datevalue 10 is 10.01.1900 00:00
in Excel date format.

 

[Steve McBride]

I actually found my answer in Google in a 1998 posting by Chip Pearson. I
just hadn't gone back far enough in time.

=Text(a1,"mmmm")

Steve

 

[Steve McBride]

Thanks for the explanation, Arvi -- I guess I was just a little thick headed
on Monday morning.

Your method even easier than Chip's method!

Steve