How to Use Excel WEEKDAY Function (Examples + Video)

Excel WEEKDAY Function (Examples + Video)


When to use Excel WEEKDAY Function

WEEKDAY function can be used to get the day of the week as a number (between 1 to 7) for the specified date.

What it Returns

It returns a number between 1 and 7 that represents the corresponding day of the week.


=WEEKDAY(serial_number, [return_type])

Input Arguments

  • serial_number: It is the serial number of the date for which you want to find the weekday number.
  • [return_type]: (Optional) You can choose the week’s start day and the value it should return. By default, the week starts on a Sunday (which means that if the day of the specified date is Sunday, then it returns 1. If it is Monday then 2 and so on..)

Additional Notes

  • By default, if you don’t use the optional argument, the function returns 1 for Sunday and 7 for Saturday.
    • You can change this by selecting from various options in return_type section.
  • Apart from serial numbers, WEEKDAY function would also work with dates entered as:
    • A result from some other function
    • A date stored as text
    • A date entered as text in WEEKDAY function (in double quotes)
  • WEEKDAY function returns a #NUM! error if the serial_num or return_type are out of range.

Excel WEEKDAY Function – Live Example

Excel WEEKDAY Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Excel Tutorials: