# Calculating the duration between 4 dates

Options
edited 12/09/19

Does anyone know the formula to count the days between 4 dates.  If the Ready to Launch date is greater than or equal to the Received IO, then the Duration would equal the number of days from Start to Launched.  Otherwise, the Duration would equal (days from Start to Ready to Launch) + (days from Received IO to Launch).

12/20/2018   1/1/2019                       1/6/2019               1/7/2019           13

12/20/2018   0                                     0                           1/7/2019           18

12/20/2018   1/6/2019                       1/1/2019               1/19/2019         30

Excel formula:

=IF(D2>=E2,DATEDIF(C2,F2,"d"),DATEDIF(C2,D2,"d")+DATEDIF(E2,F2,"d"))

Smartsheet has a function "NETWORKDAY" that will only count business days.  Here is the formula I am receiving errors on:

Thanks in advance for any assistance you can offer!

Tags:

• ✭✭✭✭✭✭
Options

You have a few extra parenthesis tucked in there. Your NETWORKDAYS functions don't need to be surrounded in them.

try replacing

(NETWORKDAYS(............))

with

NETWORKDAYS(..........)

and see if that helps.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!