Extract month from date to display month name not month number

[sureshmandadpu]

Hi Excel guys,

I have data in the form of date in a column. I want to extract month from that date. I could use month(cellnumber). It displays numeric no.

Say,
Cell A1 contains 18-Mar-16 in date format.
=month(A1) returns 3. But I want result to display as Mar instead of 3.
Is it possible?

Regards
M. Suresh

 

[Naresh Yadav]

Dear Suresh,

pls try this one.. this one will give the exact what is required to you..

=TEXT(A1,"MMM")

 

[Khalid NGO]

Hi Suresh,
If you have valid dates, and you need to see only month names, you can simply format the cell as: mmm

Or if you want this with formula:
=TEXT(A1,"mmm")

Regards,

 

[Hui]

=Text(A1,"mmm") will return the short month name eg: Feb

If you want February
=TEXT(A1,"mmmm")

Or use mmmm as a custom number format

 

[sureshmandadpu]

Thank you very much. All you guys are awesome.