WEEKDAY (Converts a serial number to a day of the week)

What Does It Do?

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.