Need Summary Sheet formula to count age in weeks of assignment

Space Trace

I have a column which is the Assigned Date of a task.

I use this formula in the summary sheet to count how many items are a week old from todays date: =COUNTIF([Assigned Date]:[Assigned Date],

What would the formulas be to count assignments that are 2 weeks old, 3 weeks old, 4 weeks old, etc.

Paul Newcome

In that case you would incorporate an AND function with @cell references like so:

=COUNTIFS([Assigned Date]:[Assigned Date], AND(@cell>=TODAY(-14), @cell< TODAY(-7)))

Paul Newcome

Are you able to finish out the existing formula?

Space Trace

Apologies. I need sheet summary formulas that give the age in weeks of an assignment where 2 weeks does not include those that are 1 week old. I suppose the formula would say that it is older than 7 days, but not older than 14 days. Here is the formula I have for the first week (7 days).

 =COUNTIF([Assigned Date]:[Assigned Date], >=TODAY(-7))

Paul Newcome

In that case you would incorporate an AND function with @cell references like so:

=COUNTIFS([Assigned Date]:[Assigned Date], AND(@cell>=TODAY(-14), @cell< TODAY(-7)))