How to convert date to weekday name or month name in Excel?


To totally unlock this section you need to Log-in


Login
Says you enter a date in one cell, and it shows as 2012/12/21. Is there a way to show only the month or the weekday, or the text of month name or weekday name, such as December, Friday?

The following methods can help you easily convert or format any kinds of date to display only the weekday name or month name in Microsoft Excel.

How to convert date to weekday name or month name in Excel?

How to convert date to weekday name or month name in Excel?

Microsoft Excel's Text function can help you to convert date to its corresponding month name or weekday name easily.

To totally unlock this section you need to Log-in


Login

1 thought on “How to convert date to weekday name or month name in Excel?”

Comments are closed.