WEEKDAY

Description Returns the day of the week that corresponds to the supplied date.

Syntax WEEKDAY ( serial_number [,order ])

Argument Description

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

[order] Optional. This argument determines how the days of the week are numbered for the purposes of this function. If this argument is omitted, 1 is used. The options are:

1 1=Sunday, 2=Monday, 3=Tuesday ... 7=Saturday

2 1=Monday, 2=Tuesday, 3=Wednesday ... 7=Sunday

3 0=Monday, 1=Tuesday, 2=Wednesday ... 6=Sunday

Argument	Description
serial_number	The date as a serial number or as text (for example, 06-21-94 or 21-Jun-94).
[order]	Optional. This argument determines how the days of the week are numbered for the purposes of this function. If this argument is omitted, 1 is used. The options are:
1	1=Sunday, 2=Monday, 3=Tuesday ... 7=Saturday
2	1=Monday, 2=Tuesday, 3=Wednesday ... 7=Sunday
3	0=Monday, 1=Tuesday, 2=Wednesday ... 6=Sunday

Examples This function returns 1, indicating Sunday:

WEEKDAY(34399.92)

This function returns 3, indicating Tuesday:

WEEKDAY("06/21/94")

See Also DAY, NOW, TEXT, TODAY