Sum of Multiple Date Ranges

Hello, 

I am trying to find the sum of Net Work Days between three date ranges. 

Expected Dock Date  &  Dock Date

Available for QC   &   QC Complete

Date Received into Sage  &  Expected Receipt

This formula isn't quite working.  It may be that not every one of these dates has been populated yet, but ideally it would be a + or - number value.

=SUM(([Dock Date]1,[Expected Dock Date]1) + ([Available for QC]1,[QC Complete]1) + ([Expected Sage Receipt Date]1,[Date Received into Sage]1)

 

Thoughts?

 

Comments