DOW()

DOW() returns a numeric value containing a digit from 1 to 7 which represents the day of the week. The digit “1” represents Sunday.

To display the name of the day of the week, use the CDOW() function.

Function Format

DOW(D)

DOW() returns a numeric value denoting the day of the week for a DateTime

If the DateTime is invalid or blank, then DOW() returns a zero value.

Valid dates are in the range January 2, 1900 to December 31, 9999.

Examples

To display the day of the week as a single digit number:

DOW(`19991124`) = 4