Which function is used to determine the day of the week for a date in excel? Give example.

• 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?