How to count how many are in the last 7 days

Options

I am trying to count how many cells are in the last 7 days

The formula I used is:

=COUNTIF([Avature Application]:[Avature Appication], AND(@cell<= TODAY(), @cell > TODAY(-7)))


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!