How it works?
It will help you to Adds or Subtracts a specified number of workdays to a Date that will give you a Future or Past Date in result.
Workday Formula breakdown:
=WORKDAY(start_date, days, [holidays])
Explanation for this:
=WORKDAY(specified date, number of work days to add/subtract, [holidays to be considered])
It will be difficult to manually calculate; if you want to calculate the future date based on a number of working days added. So here is an easy way for you use Excel’s WORKDAY formula to do this.
Follow these steps to apply Workday formula:
STEP 1: firstly you have to enter the WORKDAY function in a blank cell of your table
STEP 2: Now continue with the WORKDAY arguments:
What is the specified date?
For specifying the date selects the cell that contains the date you want to add the number of workdays to e.g.
To add work days select the cell that contains the number of work days to be added in other words it means about the number of non-weekend and non-holiday days after the start date e.g.
There you go with the future dates with the work days which are added.