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 Read More