Hello,

I have a sheet that has a status (active, closed, on-hold) and a couple of
date fields (target complete date, date completed).

I would like to compute some simple metrics such as "active" deals that are
"due next week."

In the previous example, I need to be able to count the total number of
"active" deals where the "target complete date" is in the next seven days.

I believe I can use formulas (countif, between, etc) to compute these
metrics? Any other suggestions? Pivot tables?

Open to any and all suggestions.

Thanks for you feedback.

Bryan