Finding the day of a week in Excel
I read an article this morning on Lifehacker which outlined some ways to work out what day of the week a given date was. Clever as these methods are, if you’re by a computer you can do this through Excel as long as it’s for a date after 1st January 1900:
- Open a new spreadsheet or find a blank cell and enter the date eg: 1/11/2003.
- Making sure that the cell is selected open the format cells dialog (CTRL + 1)
- Select custom number format.
- Overwrite the entry in the type box with DDDD and you can see in the sample field that what the day of the week was.
Print article | This entry was posted by Jennifer Deacon on October 13, 2011 at 9:11 am, and is filed under Excel Hints, General. Follow any responses to this post through RSS 2.0. Both comments and pings are currently closed. |
Comments are closed.