Dates Greater than 2 Days

[nniedzielski]

I have a list of Dates, Range A3:A298. I need to create a formula to Count thenumber of days in that range that are greater than 2 days old.
I have tried using the =Today() in conjunction with CountIfbut so far everything returns Zero and I can see visually that there are 15 ofthem.
What am I missing in my formula? This is what I have tried: =COUNTIF(A3:A298,TODAY()-A3:A298>2)
Thank you,

 

[Joe4]

Try:

=SUMPRODUCT(--(TODAY()-A3:A298 > 2))

 

[nniedzielski]

thanks, that solved it

 

[Joe4]

You are welcome.