trying to formulate a calculation

COUNTIF({Range}, AND(>-365, <0))

so i have a column for # days to due date and based on that, i want to count the number of tasks that are due for the past 12 months and above is the formula that i created but im getting invalid operations. please advice further. i did include the range.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!