WEEKDAY

Description

WEEKDAY returns the day of the week that corresponds to the supplied date.

Syntax

WEEKDAY ( serial_number )

 

Parameter

Description

serial_number

The date as a serial number or as text (for example, 06-21-94 or 21-Jun-94).

Remarks

WEEKDAY returns a number ranging from 1 (Sunday) to 7 (Saturday).

Examples

This function returns 1, indicating Sunday:

WEEKDAY(34399.92)

This function returns 3, indicating Tuesday:

WEEKDAY("06/21/94")

Also, see

DAY

NOW

TEXT

TODAY