"How To Excel" Mini-Tutorials|
"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.
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.
- Select the cell containing the date you want displayed as a weekday.
- From the menu select Format, Cells, and click the Number tab.
- In the Category box select Custom from the list.
- Type dddd in the Type field on the right side of the dialog box
- Select OK.
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)