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).
Formula:
=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.
