This function shows the day of the week from a date.

Syntax
=WEEKDAY(Date,Type)

Type : This is used to indicate the week day numbering system.
1 : will set Sunday as 1 through to Saturday as 7
2 : will set Monday as 1 through to Sunday as 7.
3 : will set Monday as 0 through to Sunday as 6.
If no number is specified, Excel will use 1.

Formatting

The result will be shown as a normal number.
To show the result as the name of the day, use Format, Cells, Custom and set

the Type to ddd or dddd.

Example

The following table was used by a hotel which rented a function room.
The hotel charged different rates depending upon which day of the week the booking was for.
The Booking Date is entered.
The Actual Day is calculated.
The Booking Cost is picked from a list of rates using the =LOOKUP() function.