|
|
#2
02-28-2020, 01:35 PM
|
||||
|
||||
Have a look at the Workday() function:
e.g. =WORKDAY(A1,14) will add 14 business days to date in A1. You even can include specified holiday dates to avoid in the calculation. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Calculating Quarterly Dates by Months not Days
|
Artboy34 | Excel | 3 | 01-28-2016 09:47 AM |
| Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
| Conditional formatting using a formula that will result in different colors based on dates | 19z | Excel | 3 | 05-28-2015 11:39 AM |
| Excel Formula Showing Revenue Recognition Based on Days and Months | stratcat | Excel | 4 | 03-16-2014 10:09 AM |
| Calculating 6.5hr work days | altja | Project | 3 | 02-10-2014 03:11 PM |
Windows 10 
Office 2016
Threaded Mode