MONTH() function -- more than just numeric value?

Posted by Tony White on December 19, 2001 1:00 PM

I am tracking records in a spreadsheet using values by month. Column A of each record asks for a date, and a later column (J) uses =IF(A2,MONTH(A2),"") to extract the month from column A.

I then want to use this month value to create the x-axis on a pivot table, however, the x-axis labels are displayed as "1", "2", "3", etc. which correspond to January, February, March, and so on. I would rather these values show as "Jan" "Feb" "Mar" etc, instead of "1" "2" "3" ...

Any help would be welcome!

Posted by Aladin Akyurek on December 19, 2001 1:08 PM

You can use

=IF(A2,TEXT(A2,"mmm"),"")

instead of

=IF(A2,MONTH(A2),"")

Aladin

========

Column A of each record asks for a date, and a later column (J) uses =IF(A2,MONTH(A2),"") to extract the month from column A.

Posted by Juan Pablo G. on December 19, 2001 1:09 PM

Use

=TEXT(A2,"mmmm")

in another column to get the Month names.

Juan Pablo G.

Posted by Tony White on December 19, 2001 1:13 PM

Yes, exactly what I need.

Thank you for both of your replies. This is exactly what I needed. And thank you for message board!