# Need Summary Sheet formula to count age in weeks of assignment

Options

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.

## Best Answer

• ✭✭✭✭✭✭
Answer ✓
Options

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)))

## Answers

• ✭✭✭✭✭✭
Options

Are you able to finish out the existing formula?

• edited 04/27/23
Options

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))
```
• ✭✭✭✭✭✭
Answer ✓
Options

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)))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!