WEEKDAY Function Explained
The WEEKDAY function in Microsoft Excel returns a number from 1 to 7 corresponding to the day of the week of a given date. It takes two arguments: a date and an optional return type. The return type can be either 1 (for Sunday as the first day of the week) or 2 (for Monday as the first day of the week). If the return type is omitted, it defaults to 1.
WEEKDAY Function Syntax
WEEKDAY(serial_number, [return_type])
- serial_number: A number representing the date you want to find the weekday of. This number is usually the result of another function, such as the DATE function.
- return_type: (optional) A number representing the type of return value you want. 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday, 11 = 1st day of week, 12 = 2nd day of week, 13 = 3rd day of week, 14 = 4th day of week, 15 = 5th day of week, 16 = 6th day of week, 17 = 7th day of week.