The Excel WEEKDAY function returns the day number of the week from a date serial number. The default return type ranges from 1 for Sunday, through to 7 for Saturday, but you can choose from a list of return types.
Excel WEEKDAY Function Syntax
| Syntax: | =WEEKDAY(serial_number, [return_type]) |
| serial_number | a date in a format Excel recognises known as the date-time serial number. |
| return_type | The return type argument is optional, if omitted it will default to return type 1. |
Tip: Return types 1 and 17 for Sunday are the same as one another. Type 1 is only included for backward compatibility with earlier versions of Excel. Likewise, return type 2 and 3 for Monday.
Excel WEEKDAY Function Examples
Free eBook - Working with Date & Time in Excel
Everything you need to know about Date and Time in Excel, including all Date functions explained with examples - Download the free eBook and Excel file with detailed instructions.
Enter your email address below to download the sample workbook.
Download the Excel Workbook and PDF. Note: This is a zip file including an Excel workbook with detailed instructions and a PDF version for your reference.
Related Tutorials
| Excel WEEKNUM Function | Returns an integer representing the week number (from 1 to 54) of the year from a date serial number |
| Excel ISOWEEKNUM Function | Returns the ISO week number of the year for a given date |
| Excel MONTH Function | Returns the month from a date serial number. |
| Excel DAY Function | Returns the day (of the month) from a date serial number |
| Excel YEAR Function | Returns the year from a date serial number |
| Excel End of Period Dates | Calculate fiscal period end dates |
