![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have a current formula that counts out 10 calendar days from an entered date. if the calculated date lands on a weekend or holiday, it currently displays the previous business day (usually a Friday). I would like it instead to display the following business day (usually a Monday).
I'm not sure which part of the formula to adjust to make that change. I've attached a snippet of the current formula. Any help would be greatly appreciated. Thanks! |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Fifteen Days From Today's Date, (Not Counting Saturday & Sunday).
|
StephenRay | Word VBA | 13 | 07-26-2017 11:22 AM |
| Sum Function over Today +/- 60 Days | gabeha | Excel | 2 | 09-12-2014 01:13 AM |
| Using Outlook Today Calendar Days | cwksr | Outlook | 0 | 08-13-2014 10:57 AM |
| Conditional formatting of Today +21 days? | SHERMAN | Excel | 3 | 12-20-2010 08:08 AM |
| Creating an Auto-Calc'd Date? Today+7 Days? | SoCalTelephone | Word | 0 | 10-06-2010 10:27 AM |