WORKDAY Function To Find Working Days
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...