Working with Worksheet Functions
Use the WEEKDAY() worksheet function to determine what day of the week any date falls on. Here’s how:
Enter a date in any cell.
In any other cell, type
Click the cell with the date in it.
The formula cell has a number from 1-7 in it. Given that Sunday=1, and Monday=2, you should be able to figure out what day the date you entered falls on.