|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#5
05-21-2018, 01:11 AM
|
|||
|
|||
WORKDAY() is a bit tricky function. It is logical to assume, that when you want to move the date only when it falls on weekend, and otherwise to let it unchanged, the 2nd parameter will be 0. Forget logic there - with 0 as parameter you get same date back - workday or not. Instead you have to use
Code:
=WORKDAY(E6-1,1) 
|
|
|
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 |
Windows 8 
Office 2016
Threaded Mode