Calculating the duration between 4 dates

Jericho

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).  

Start-C          Ready to Launch-D    Received IO-E    Launched-F    Duration

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:  

=IF([Ready for Launch]2 >= [Received IO]2, (NETWORKDAY([Start]2, [Launch]2)), (NETWORKDAY([Start]2, [Ready for Launch]2)+NETWORKDAY([Received IO]2, [Launch]2)))

 

Thanks in advance for any assistance you can offer!

 

Paul Newcome

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.