COUNTIFS if a Date cell is within 30 Days


Is it possible to COUNTIFS with one of the criteria being a date that is equal to or within 30 days to that set in another cell?

In the past I have used a helper column to count the days and just count the cells that fell within the number of day <=30, <60, etc.

Any help would be much appreciated.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!