WORKDAY Function

The WORKDAY function is a date and time function which takes "start_date, days, holidays" as argument and returns a number that represents a date, which is the indicated number of working days before or after a date (the starting date).


=WORKDAY(start_date, days, holidays)
In the above syntax, the argument start_date denotes the start date, days denotes the number of nonweekend and nonholiday days before or after start_date and holidays denotes the dates which are excluded from the working calendar i.e. state and federal holidays.

Video Tutorial:

Let us see how the WORKDAY function returns the number of working days, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question