Day of Week for Date Number [DayOfWeekFor#]

Return to Complete List of Functions

The Day of Week for Date Number function determines the day of the week (1=Sunday) for a date specified as a date number. Parameters ------------------ Date Number     The number of days between a given date and December 30, 1899.                           This value is typically generated based on the Date As Number function. Function Value ------------------------ This function extracts the day of the week from a date specified as year, month, and day. The resultant value is a number from 1 to 7. Value        Meaning -------------------------------     1           Sunday     2           Monday     3           Tuesday     4           Wednesday     5           Thursday     6           Friday     7           Saturday