WEEKDAY

Definition: The WEEKDAY function in Excel is used to return the day of the week for a given date.

Syntax: ==WEEKDAY(serial_number, [return_type]).

Situation: This formula is appropriate in situations where you need to determine the day of the week for a given date.

Example: If you have a date in cell A1 that is January 1, 2022, you would use the formula =WEEKDAY(A1). This would return a value of 7, which indicates that January 1, 2022, is a Saturday.