Pages

Thursday, November 10, 2011

Use custom formatting to display the day of the week - Date and Time Functions - Microsoft Excel Tutorials


Use custom formatting to display the day of the week Using Microsoft Excel

How to show the day of the week in Microsoft Excel. A worksheet contains dates in Column A. Use this tip to get the corresponding day of the week of these dates.

To display weekdays using customized formatting:

1. Select cells B2:B10 and type the formula =A2.
2. Press <-Ctrl+Enter->.
3. From the Format menu, select Cells.
4. Select the Number tab and click on Custom below Category.
5. In the Type box, change the number format to "dddd".
6. Press OK.


Watch the Video Tutorial - https://www.youtube.com/watch?v=lkEw0eHF2O0

 

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews