Count if dates are within the next 7 days

Tynisha
Tynisha
edited 12/09/19 in Formulas and Functions

Hello,

I'm trying to use the COUNTIFS function to search a reference column full of dates to count how many are within the next 7 days. For the criteria portion of the formula, I've tried using, "<TODAY(7)", "<TODAY() + 7", but they are not providing me with the correct (if any) result. I would like to avoid having to create a workaround by adding a new column to identify if the aforementioned criteria is true, then counting it that way. 

What am I missing? HELP!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!