difference in dates for specified time

**EYES** · 07-19-2009, 04:38 PM

Formula query
Column “A” list of dates correspondence in
Column “B” list of dates correspondence reply out
Need to calculate how many times the difference between date in and reply date is <= 5 in a specific time period.
The start date is entered in say, “K1”
The end date is entered in say, “L1”
Also calculate difference in dates between 14 days and 21 days for time period
Also with reply in column “B” not sent until over 28 days
I have tried SUMPRODUCT with (date_in=K1)*(date_out<=L1) for the dates but unsure how to define <=5

Any help please

**daddylonglegs** · 07-19-2009, 04:41 PM

Try

=SUMPRODUCT((date_in>=K1)*(date_out<=L1)*(date_out-date-in<=5))

**EYES** · 07-19-2009, 05:08 PM

I've tried that one but get a result of 0 and I know there should be 3.
It would be easier if I had a NETWORKDAYS column with the difference and take the time period from that but I thought there might be another way to do it.

Thanks for your help anyway

**daddylonglegs** · 07-19-2009, 05:28 PM

The formula I suggested should work, but it counts all days, you didn't say you wanted to count only weekdays. If so then, yes, the easiest way is to have a column with a NETWORKDAYS formula......