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

nmazardw

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)")

Paul Newcome

It is the closing parenthesis after the range that needs to be removed. Missed it on the first go-around.

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

Paul Newcome

Try removing the quotes.

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

Sean Morgan

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

Paul Newcome

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

Sean Morgan

@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

Paul Newcome

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

nmazardw

Good Morning,

I tried removing the quotes;

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

Sean Morgan

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

Paul Newcome

It is the closing parenthesis after the range that needs to be removed. Missed it on the first go-around.

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

nmazardw

Thank you so much Paul, that worked!

Paul Newcome

Happy to help! 👍️