Quote:
Originally Posted by Gord Dibben
|
To add days excluding weekends, you can do as below:
Select a blank cell and type this formula =WORKDAY(A2,B2), and press Enter key to get result.
Tip: In the formula, A2 is the start date, B2 is the days you want to add.
doc add days exluding weekend holiday 1
Now the end date which add 45 business days excluding weekends has been shown.
doc add days exluding weekend holiday 2
Note: If the calculated result is a 5-digit number, you can format it to date with clicking Home Number Format Short Date.
If you have a range of cells containing the holidays, and now you want to add days excluding weekends and these holidays to a given date, how can you handle it?
Select a blank cell and type this formula =WORKDAY(A2,B2,B4:B6), then press Enter key to get the result.
I hope these steps will be helpful!
Tim Paine