Date is within 7 days of today calculation

I have a date field (field name = Reim due date) that is a calculation based on another date field.

I am trying to create a countif summary sheet field that says 'count if the Reim due date is within the next 7 days.' Formula below is coming back unparseable.

=COUNTIF([Reim due date]:[Reim Due date]),>TODAY(+7))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!