Hot Do You Convert Dates To Weekday/Month Name With TEXT Function in Excel

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:

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”).