Weekday in Excel

Weekday in Excel

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

Microsoft Excel Function

=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.

                                                                  

Content Data

Date	Weekday
Sun 01-Jan-17	1	=WEEKDAY(C4)
Mon 02-Jan-17	2	=WEEKDAY(C5)
Tue 03-Jan-17	3	=WEEKDAY(C6,1)
Wed 04-Jan-17	3	=WEEKDAY(C7,2)
Thu 05-Jan-17	3	=WEEKDAY(C8,3)