Date ranges, if then formulas?

[excel-lent13]

Hi,

I need a way to calculate number of dates for multiple date ranges. I have attached a sample table. Is there a way to use formulas to get this done faster? Basically, i need to figure out how many days are impacted for various construction schedules for various periods throughout the year. See attachment. Thanks in advance!

[Richard Buttrey]

Please upload the workbook rather than a picture and manually add the results you expect, clearly identifying which cells are results and which original data.