How to write a COUNTIF formula that counts the amount of rows where the date is TODAY-date>80 AND

09/21/21
Answered - Pending Review

TODAY-date<99?

Answers

  • Hello @Abbie G

    Try this:

    =COUNTIFS([Column20]:[Column20], >TODAY(+80), [Column20]:[Column20], <TODAY(+99))
    
    

    Just replace [Column20]:[Column20] with the column that your Date is in.

    Let me know how it goes!

    Lidiya Shutaya

    [email protected]

Sign In or Register to comment.