Working with Worksheet Functions

Close Window 

Determining the Day of the Week

Use the WEEKDAY() worksheet function to determine what day of the week any date falls on. Here’s how:

  1. Enter a date in any cell.

  2. In any other cell, type

=weekday(

  1. Click the cell with the date in it.

  2. Press Enter.

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.

(Posted 6/9/2000)