COUNTIF Date is in the next 180 days from today
I'm trying to use the COUNTIF function to search a date column to count how many dates are within the next 180 days from today...but my formulas aren't working correctly.
Failed Attempt 1: =COUNTIF([Renewal Date]2, >=TODAY(+180))
Failed Attempt 2: =COUNTIF([Renewal Date]2, >=TODAY()180)
What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!