WEEKDAY()
Syntax. WEEKDAY(serial_number;return_type)
Definition. This function converts a date (serial number) into a weekday number. The weekday is returned as an integer from 1 (Sunday) through 7 (Saturday).
Arguments
serial_number (required). The date for which the weekday number is calculated.
return_type (optional). A number (1, 2, or 3) indicating the type of the return value. The types are defined as follows:
1 (or no value). 1 indicates Sunday, 2 indicates Monday, and so on, with 7 indicating Saturday.
2. 1 indicates Monday, 2 indicates Tuesday, and so on, with 7 indicating Sunday.
3. 0 indicates Monday, 1 indicates Tuesday, and so on, with 6 indicating Sunday.
In Excel 2010, the return types are extended. You can choose these additional types: ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
