Posts tagged format
Finding the day of a week in Excel
Oct 13th
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.