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.