# WEEKDAY

WEEKDAY(serial_number [,return_type])

Returns the day of the week for a given date.

 serial_number The date as a serial number. return_type (Optional) The number that specifies on what day the week starts:1 = Sunday (1 to 7) (default)2 = Monday (1 to 7)3 = Monday (0 to 6)11 = (Added in 2010) Monday (1 to 7)12 = (Added in 2010) Tuesday (1 to 7)13 = (Added in 2010) Wednesday (1 to 7)14 = (Added in 2010) Thursday (1 to 7)15 = (Added in 2010) Friday (1 to 7)16 = (Added in 2010) Saturday (1 to 7)17 = (Added in 2010) Sunday (1 to 7)

 REMARKS
 * This function returns a number between 0 and 7.* The "serial_number" can be a date value, a serial number or a reference to a cell containing a date.* The "serial_number" cannot be a text string.* If "return_type" is left blank, the 1 is used.* If "return_type" = 1, then Sun = 1, Mon = 2, Tue = 3, Wed = 4, Thu = 5, Fri = 6 and Sat = 7.* If "return_type" = 2, then Mon = 1, Tue = 2, Wed = 3, Thu = 4, Fri = 5, Sat = 6 and Sun = 7.* If "return_type" = 3, then Mon = 0, Tue = 1, Wed = 2, Thu = 3, Fri = 4, Sat = 5 and Sun = 6.* If "return_type" = 11, then Mon = 1, Tue = 2, Wed = 3, Thu = 4, Fri = 5, Sat = 6 and Sun = 7.* Alternatively you could use a custom number format of "dddd" - Example 9.* You can use the DATE function to return the date serial number given a year, month, day.* You can use the ISOWEEKNUM function to return the number of the ISO week of the year for a given date.* You can use the NOW function to return the serial number of the current system date and time.* You can use the TEXT function to convert a value to a specified number format.* You can use the WEEKNUM function to return the week number in the year.* You can use the WORKDAY function to return the serial number that is a given number of working days before or after a date.* In Excel 2010 the "return_type" numbers 11 to 17 were added.* The equivalent VBA function is VBA.WEEKDAY* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =WEEKDAY(B1) = 6 01 July 1977 (Friday) 2 =WEEKDAY(DATE(1977,7,1)) = 6 02 July 1977 (Saturday) 3 =WEEKDAY(B1,1) = 6 03 July 1977 (Sunday) 4 =WEEKDAY(B1,2) = 5 =NOW() = 02/07/2022 5 =WEEKDAY(B1,3) = 4 =NOW() = 44744 6 =WEEKDAY(B2,2) = 6 7 =WEEKDAY(DATE(1977,7,2),2) = 6 8 =WEEKDAY(1/7/1977,2) = 6 9 =WEEKDAY(NOW(),2) = 6 10 =WEEKDAY(B4,2) = 6 11 =WEEKDAY(38093,2) = 5 12 =TEXT(WEEKDAY(DATE(1977,7,1)),"dddd") = Friday 13 =TEXT(WEEKDAY(DATE(2004,7,1)),"dddd") = Thursday 14 need to generate #NUM!

 1 - What day was the 1st July 1977. This returns 6 which represents Friday.2 - What day was the 1st July 1977 when submitted using the DATE function.3 - What day was the 1st July 1977 when the week starts on a Sunday. This returns 6 which represents Friday.4 - What day was the 1st July 1977 when the week starts on a Monday (starting at 1). This returns 5 which represents Friday.5 - What day was the 1st July 1977 when the week starts on a Monday (starting at 0). This returns 4 which represents Friday.