Microsoft Excel Tips - Function shows the day of the week from a date


#1
	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