Month mmmm format


S

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
 
Ad

Advertisements

A

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.
 
S

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
 
Ad

Advertisements

S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top