CODEWITHSUNDEEP
excelexcel-formula
Fero
Fero

Reputation: 13315

How to get name of the month in MS EXCEL

Let's say in column A1, I have the below value in the format dd/mm/yy.

13/04/18

I need to print the name of the month which i APRIL in column A2.

How can we achieve that?

I've tried the below:

  1. =TEXT(date,"mmmm") will work only if the format is mm/dd/yy.

  2. I've tried to change the date format to mm/dd/yy and then to the month name which works but I don't need one unwanted column

    IN B1 column =DATE(RIGHT(A1,2)+2000,MID(A1,4,2),LEFT(A1,2))

    IN C1 column =TEXT(date,"mmmm")

Any help would be appreciated. Thanks

Upvotes: 1

Views: 466

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

so combine the two:

=TEXT(DATE(RIGHT(A1,2)+2000,MID(A1,4,2),LEFT(A1,2)),"mmmm")

Upvotes: 1

Related Questions