DEFINITION: Workday Function Need A Valid Date As Parameter And In Returns. It Return Working Day In Date Serial Format For Future Or Past. To Change The Date Serial Number To A Date You Must Set Format As Date. Workday Function Has Sat–Sun As Default Weekends And It Exclude Weekends And Any Dates Set As Holidays. Use A (+) Number As Days For Future Dates And A (-) Number For Past Dates.
Note: This Function Does Not Include The Start Date Day.
IMPLEMENT:
(1) Parameter Start Date – The Date From Where To Start.
(2) Parameter Days – Number Of Working Days After Or Before Start Date.
(3) Holidays – [Optional] A List Or A Single Date That Considered As Non-Working Days. You Can Have Some Date Listed In Cells Which You Can Set As Holidays But You must Fix It With Dollar Sign. Ex:- $A$1:$A$5
Example To Find 8 Working Days:
