Excel month name, abbreviation from date

In Excel the Text formatting formula (=TEXT()) is capible of re-formatting Excel’s built in date storage format.

Type Date Example Result Formula
Full Month Name 1/25/2016 January =TEXT(B2, “mmmm”)
Abbreviated Month 1/25/2016 Jan =TEXT(B3, “mmm”)
Two digit month number 1/25/2016 01 =TEXT(B4, “mm”)
Single/double month number 1/25/2016 1 =TEXT(B5, “m”)

Related search:

  • excel text month name