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

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

nmazardwnmazardw
edited 05/21/20 in Formulas and Functions

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

Best Answer

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try removing the quotes.

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

  • Sean MorganSean Morgan admin
    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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

  • @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 NewcomePaul Newcome ✭✭✭✭✭

    @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.

  • Sean MorganSean Morgan admin
    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!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! 👍️

Sign In or Register to comment.