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
|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.
|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|