Site icon ExcelNotes

How to Convert a Date to the Month Name

Text FunctionData Formatting

To convert a date to the month name, you can use the Text Function. Otherwise, please check how to convert a date to the month numbers.

To convert a date to the month name with 3 letters (e.g., Aug), please copy the formula and change the cell name.

=Text(A1,"MMM")

To convert a date to the month with all letters (e.g., August), please copy the formula and change the cell name.

=Text(A1,"MMMM")

Alternatively, please follow the steps below to format the date into the month name:

Step 1: Select the date range and click the "Home" tab from the ribbon;

Step 2: Click the right bottom corner in the "Number" group;

Step 3: In the "Format Cell" window, click "Custom" and type "mmm" in the type box to have the month name with 3 letters and type "mmmm" in the box to have the full month names;

Step 4: Click "OK" at the bottom.

Exit mobile version