|
|
#1
02-28-2020, 10:35 AM
|
|||
|
|||
Formula for calculating dates based on Business Days
I've been put in charge of managing delivery of of number of regular reports. The dues dates for many of these reports are basically a specific number of business days before/after a trigger date.
For example, a certain set of reports is due 15 business days after a version release. I need a formula that lets me set the rule for a report so that in Excel, I can enter the trigger date and Excel will calculate the due date. Is this doable? thanks 
|
|
#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.
|
|
#3
03-02-2020, 09:05 AM
|
|||
|
|||
|
Just what I needed! Thanks!
|
|
|
|
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
Linear Mode
