Count If greater than or equal to 30 days from today?

edited 05/21/20

Hello,

I am trying to find how many dates are greater than or equal to today that are past 30. I missing something the function isnt working.

Formula —

=COUNTIF([Account Corrections]:[Account Corrections]), ">=TODAY(-30)")

• ✭✭✭✭✭✭

Try removing the quotes.

=COUNTIF([Account Corrections]:[Account Corrections]), >= TODAY(-30))

• Employee
edited 05/23/20

Hello @nmazardw ,

Based on the formula provided, I feel this is due to the quotes used in the formula.

Quotes are used to search for a specific value, E.G COUNTIF([All Employees]:[All Employees], "John"

Please see my example formula I used: =COUNTIF(Column 3]:[Column 3]), >= TODAY(-30))

Kindest Regards

Sean

• ✭✭✭✭✭✭

@Sean Morgan You didn't finish out your formula to show your criteria.

• Employee

@Paul Newcome Thanks!

I think it may have been a dodgy copy and paste job.

I blame the 4 hours of sleep I got, due to my wild daughter 😂

Regards

Sean

• ✭✭✭✭✭✭

@Sean Morgan Sure thing. I also noticed just now an extra closing parenthesis tucked in right after the range.

• Good Morning,

I tried removing the quotes;

=COUNTIF([Account Corrections]:[Account Corrections]), >= TODAY(-30)) returns back #UNPARSEABLE.

• Employee
edited 05/26/20

Hello @nmazardw ,

Can you please provide a screenshot of your sheet and show where you are entering this formula, whilst removing/hiding any sensitive data?

Regards

Sean

• Thank you so much Paul, that worked!

• ✭✭✭✭✭✭

Happy to help! 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!