Trying to Count number of items with a date in the next 60 days

Debbie Petersen

Hi David - yes, that formula you posted says unparseable.

Andrée Starå

@dskpetersen

Glad we got it working!

@David Tutwiler It was a parenthesis too much.

Here's the working one (in my region).

=COUNTIFS({Master Bid List Range 6}; @cell >= TODAY(); {Master Bid List Range 6}; @cell <= TODAY(60); {Master Bid List Range 7}; <=0,74)

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

David Tutwiler

@Andrée Starå So close

Andrée Starå

@David Tutwiler

Yes, those are so easy to miss.

Debbie Petersen

Hi - This formula has worked beautifully for me so I decided to try to pare down some metrics and now I'm wondering if it's possible to write this same type of formula, but instead of comparing only the criteria in one column( Anticipated Start Date, It would be comparing 2 different columns (Anticipated Start Date and Actual Start Date) and the criteria is the same in the next 60 days) Is that possible? Tried "IF" and "OR" in the formulas and not working so maybe not possible?