|
|
#1
08-02-2017, 12:39 PM
|
|||
|
|||
weekend to monday logic problem
I'm writing a timeline sheet and need to know the formula if a timeline ends on a Saturday/sunday to default to the following Monday IE:
inspection deadline is 10 days ( not workdays) but if it ends on a weekend /holiday it needs to default to the following Monday. any help would be greatly appreciated 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem) | stormrider2230 | Excel | 1 | 01-20-2016 01:41 PM |
 force task start on monday
|
pascalbidouille | Project | 2 | 07-01-2015 01:57 PM |
| 'Monday to Friday' Date calculation help needed | ballst | Word | 10 | 12-16-2014 09:51 AM |
|
Weekend Working
|
Planner18 | Project | 1 | 10-29-2014 11:30 AM |
| Calculating Weekend Allowance | WinIDS | Excel | 6 | 09-02-2011 01:27 AM |
Windows 10 
Office 2016
Threaded Mode