Home > Forum Home > Analyzing Corporate Financial Data > Excel Formula for day of week > Format cells to show dates as the day of the week Share

Format cells to show dates as the day of the week

Excel Help for Format Cells To Show Dates As The Day Of The Week in Analyzing Corporate Financial Data


Forum TopicLogin

Format Cells To Show Dates As The Day Of The Week

Rate this:
(4/5 from 2 votes)
Confused
  1. Select the cells that contain dates that you want to show as the days of the week.
  2. On the Home tab, click the dropdown in the Number Format list box, click More Number Formats, and then click the Number tab.
  3. Under Category, click Custom, and in the Type box, type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on).

Let me know if this helps.

Regards,
Jerry.
 Jerry M
 Posted by on
 
View Full Post

Excel templates and solutions matched for Format cells to show dates as the day of the week:

Solutions: Serial Number to Barcode