Microsoft Excel’s TEXT function can help you to convert a date to its corresponding month name or weekday name easily.
TEXT(A2,”dddd”)
TEXT(A2,”ddd”)
TEXT(A2,”mmmm”)
TEXT(A2,”mmm”)
In a blank cell, please enter this formula =TEXT(A2,”mmmm”), in this case in cell C2. , and press the Enter key. And then drag this cell’s AutoFill handle to the range as you need.
And the date have been converted to month name. See screenshot:
![](https://cdn.extendoffice.com/images/stories/doc-excel/date-month-week/doc-convert-date-to-weekday-month-03.png)
Note: You can change the “mmmm” to other format code according to above table. For example, you can also convert a date to the weekday name with the formula =TEXT(A2,”dddd”).