|
|
#3
12-12-2018, 09:30 AM
|
|||
|
|||
You calculate time difference in days? So include it into MAX() function (or MIN(), depending on sign of calculated difference). Something like
Code:
=MAX(Date2-Date1, 30) 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
| Excel Date Calculation | artlk | Excel | 3 | 11-20-2017 09:55 AM |
|
Date field - future date calculation + only business days
|
neon4 | Word | 7 | 01-21-2016 02:21 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