- The WEEKDAY function in Excel accepts a date and returns a number between 1 and 7 that represents the weekday. WEEKDAY returns 1 for Sunday and 7 for Saturday by default, although this can be changed. To check the weekday, utilise the WEEKDAY function inside other calculations.
- The WEEKDAY function accepts a date and produces a number from 1 to 7 that represents the weekday. The serial number and return type arguments are passed to the WEEKDAY function. Serial number must be a valid Excel date formatted as a serial number. Return type is a numeric code that specifies which day of the week is treated as the first.
- WEEKDAY (serial_number, [return_type])
- 1- Sunday
- 2 -Monday
- 3 -Tuesday
- 4 -Wednesday
- 5 -Thursday
- 6 -Friday
- 7 -Saturday
Read More: What is the use of NameBox in MS-Excel?
