Counting data with Time duration

Hi everyone,

Please help me with the right formula.

I have 21 resolved cases for the month of January and I would like to know how to get the data for the cases resolved in less than a week and more than a week.

Sad to say I cannot attached the file because my karma point is just 1

Please show example data and the desired result. Also, what formulas have you tried so far? Take a look at Guidelines for asking - #4 by jimk.

To provide files, you might use free services like

One of many possible ways is to use the SUMPRODUCT function

Like as in this demo - counting-time-duration.ods