|
|
#2
11-17-2017, 11:07 AM
|
|||
|
|||
In attached file is a possible solution.
NB! It's better to leave the Weekday() function with European format - much easier for calculations when weekends are days 6 and 7. PS. Without additional sheet it will be nearly impossible. You must move the date away from weekend, then move away from holiday when date happens to be one, then again you have to check that new dates aren't weekends and when , then move the date, then you have anew to check for holidays, etc. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Age calculation with date and DOB fields
|
Xaand | Word | 9 | 09-29-2023 11:38 AM |
|
Date field - future date calculation + only business days
|
neon4 | Word | 7 | 01-21-2016 02:21 PM |
|
Rules based due date calculation
|
dlowrey | Excel Programming | 3 | 05-12-2013 08:30 PM |
|
Date Calculation
|
Lights | Excel | 5 | 04-18-2012 04:31 AM |
| calculation of start date | ketanco | Project | 1 | 02-29-2012 07:01 AM |
Windows 8 
Office 2016
Threaded Mode