WEEKDAY Function (Functions in Excel)
Date | Weekday | |
Thu 01-Jan-98 | 5 | =WEEKDAY(C4) |
Thu 01-Jan-98 | 5 | =WEEKDAY(C5) |
Thu 01-Jan-98 | 5 | =WEEKDAY(C6,1) |
Thu 01-Jan-98 | 4 | =WEEKDAY(C7,2) |
Thu 01-Jan-98 | 3 | =WEEKDAY(C8,3) |
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. |
Booking Date | Actual Day | Booking Cost |
7-Jan-98 | Wednesday | £ 30.00 |
=LOOKUP(WEEKDAY(C34),C39:D45) |
Booking Rates | |
Day Of Week | Cost |
1 | £50 |
2 | £25 |
3 | £25 |
4 | £30 |
5 | £40 |
6 | £50 |
7 | £100 |
0 comments:
Post a Comment