|
|
#3
02-01-2018, 08:48 AM
|
|||
|
|||
=MAX(B1, C1, D1)-A1
Excel treats dates as numbers with +1 being an extra day, so this will get you the number of calendar days between submission and the last test. It gets somewhat more complex if you need business days or something, but for calendar days it's really easy. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Index using multiple conditional tests
|
RLS41155 | Excel | 2 | 12-02-2015 04:59 AM |
|
Need a formula to calculate turnaround time
|
Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
| Measuring Turnaround Time | quirkycanuck | Outlook | 0 | 03-03-2015 01:22 PM |
|
Calculating Turnaround Time
|
shstone | Excel | 4 | 12-11-2014 12:39 PM |
|
Calculating turnaround times in excel
|
Swooshy | Excel | 14 | 11-21-2013 01:04 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode