What is the syntax of WEEKDAY Function in Excel?

The Excel WEEKDAY function takes a date and returns a number between 1-7 representing the day of week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable. You can use the WEEKDAY function inside other formulas to check the day of week.

  • Purpose: Get the day of the week as a number
  • Return value: A number between 0 and 7.


=WEEKDAY (serial_number, [return_type])


  • serial_number - The date for which you want to get the day of week.
  • return_type - [optional] A number representing day of week mapping scheme. Default is 1.


By default and without a value fore return_type, WEEKDAY starts counting on Sunday:

=WEEKDAY("3-Jan-21") // Sunday, returns 1 
=WEEKDAY("4-Jan-21") // Monday, returns 2