Count # of records based on difference between 2 dates

[KathrynJ]

I need a formula to first calculate the number of days between 2 dates, and then sum the number of records based on # of days criteria.

I've tried using DATEDIF(start-date,end_date,"d") and it will give me the number of days, but I don't know how to then sum the number of records within a "days range".

See attached sample file. Row 1 lists the criteria, row 2 should give the results.

 

[NARAYANK991]

Hi ,

See if this is correct.

Narayan

 

[KathrynJ]

Yes, this is perfect. Thank you very much!