WEEKDAY supports several numbering schemes, controlled by the return_type argument. Return_type is optional and defaults to 1. The table below shows available return_type codes, the numeric result of each code, and which day is the first day in the mapping scheme. Note: the WEEKDAY function will return a value even when the date is empty. Take care to trap this result if blank dates are possible.


By default and without a value fore return_type, WEEKDAY starts counting on Sunday: To configure WEEKDAY to start on Monday, set return_type to 2: In the example shown above, the formula in D5 (copied down) is: The formula in E5 (copied down) is:


By default, WEEKDAY returns 1 for Sunday and 7 for Saturday. WEEKDAY returns a value (7) even if the date is empty.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.