The WEEKDAY function returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.

WEEKDAY takes 1 required argument and 1 optional argument:

Syntax: WEEKDAY(serial_number, [return_type])

Using the WEEKDAY function:
Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2014 is serial number 41640 because it is 41,640 days after January 1, 1900.
The arguments for the WEEKDAY function are:
Argument Required? Description
serial_number Required A sequential number that represents the date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use WEEKDAY(2014,3,17) for the 17th day of March, 2014. Problems can occur if dates are entered as text.
return_type Optional A number that determines the type of return value.
Possiblereturn_typeargument values:
A couple more things:
If serial_number is out of range for the current date base value, a #NUM! error is returned.
If return_type is out of the range specified in the table above, a #NUM! error is returned.


The WEEKDAY function returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
comments powered by Disqus