Weekday Function

Description

Returns a whole number representing the day of the week.

Syntax

Weekday(date)

The date named argument is limited to numbers or strings, in any combination, that can represent a date. If date contains no valid data, Null is returned.

Return Values

Value

Description

1

Sunday

2

Monday

3

Tuesday

4

Wednesday

5

Thursday

6

Friday

7

Saturday


See Also

Date Function, Date Statement, Day Function, Month Function, Now Function, Year Function.

Example

This example uses the Weekday function to obtain the day of the week from a specified date.


MyDate = #February 12, 1969#    ' Assign a date.
MyWeekDay = Weekday(MyDate)    ' MyWeekDay contains 4 since it 
    ' was a Wednesday.