Returns the day of the week corresponding to a specified date as a number from 1 to 7.

Syntax

DOW(<expD>)

<expD>

The date whose corresponding weekday number you want to return.

Description

DOW( ) returns the number of the day of the week on which a date falls:

Day

Number

Sunday

1

Monday

2

Tuesday

3

Wednesday

4

Thursday

5

Friday

6

Saturday

7

To return the name of the day of the week instead of the number, use CDOW( ). DOW( ) returns zero for a blank date.