"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Showing Just The Day Of The Week

Sometimes you may be using dates in your worksheet and want the cell to show the day of the week (i.e. Sunday, Monday,..) rather than a date. You could simply type in the day of the week in the cell, but if you have formulas in your worksheet that refer to that cell, those formulas would get messed up. What you need to do is create a custom number format for the cell containing the date.

To create a custom number format for the day of the week is easy.

  1. Select the cell containing the date you want displayed as a weekday.
  2. From the menu select Format, Cells, and click the Number tab.
  3. In the Category box select Custom from the list.
  4. Type dddd in the Type field on the right side of the dialog box
  5. Select OK.
Now, go back and try that again, but this time notice as you type each d in the Type field how the sample format on the top of the dialog changes. You can use this technique to display the day of the week in four different formats: 1-digit number, 2-digit number, 3-digit text, or full-word text.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.