Convert Data to Weekday name or Month Name

This post will explain that how to convert a date to weekday name or month name or year? How do I change a date in one cell to display only the weekend name or month name with an Excel formula? For example, if you want to convert a date 11/6/2018 to Tuesday or November only, you can follow the below ways to convert it.

Convert Data to Weekday name or Month Name with Text Function

You can use the Excel Text formula to convert date to weekday name or month name.

If you want to convert date to Month name only, just type the below formula in Cell C1, and then press Enter key.

=TEXT(B1,”mmmm”)

Then drag the Auto Fill Handle over other cells to apply this formula.

convert data to weekday or month1

If you want only to convert date to weekday name, just change the format code “mmmm” to “dddd” in the above formula. Type the below formula in Cell D1, and then press Enter key.

=TEXT(B1,”dddd”)

convert data to weekday or month2

Convert Data to Weekday name or Month Name with Format Cell feature

You can also use the Format Cell feature to convert the format of date in one cell, just do the following steps:

#1 select the cells that contain dates that you want to convert to month names or weekday names.

#2 right click on those cells, select the Format Cells… menu from the drop down menu list.

convert data to weekday or month3

#3 the Format Cells window will appear.

#4 choose Custom category under Category section, and then input “mmmm” format code in Type text box to display month name or input “dddd” format code to display weekday name only. Then click OK button.

convert data to weekday or month4

#5 let’s see the last result.

convert data to weekday or month5

Last, if you want the result to be shown in the different cell, you should use the Text function to convert date to weekday name or month name. If you want to convert to the same cell, you’d better use the format cell feature to convert date.


Related Functions

  • Excel Text function
    The Excel TEXT function converts a numeric value into text string with a specified format. The TEXT function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The syntax of the TEXT function is as below: = TEXT (value, Format code)…
Related Posts

Phone Number Format in Excel

Sometimes when we import phone numbers from external sources, the formatting of the phone numbers is removed. Even if in some situations the phone numbers are not imported from external resource, sometimes the phone numbers in worksheet are not displayed ...

Add Leading Zeros in Excel

To pad a number with zeros, you need to add leading spaces and/or carriers. For example, if the original digit contains 2 digits, three additional characters will be added on before it. If there are 3 digits in total, allocating ...

How to Auto Fill Weekdays or Weekends in Excel

Sometimes we may want to enter a sequence of days in excel for some purpose, and we can press Ctrl+; to insert current date into cell, and then drag the cell down to attach following days into other cells, then ...

How to Change Date to The Day of Week in Excel

In excel, we can type a date properly if set cell format as ‘Date’. If there is a list includes multiple dates, is there any way to convert these dates to the days of week accordingly? Actually, there are some ...

How to Create Increment Number with Texts in Excel

Sometimes we want to fill 1,2,3,4,5… into each cell in a column, for implement this we can enter 1 in the first cell and then drag fill handle down to fill the following cells. But if there are some texts ...

Sidebar