COUNTIF Function issue

[Gweduc]

I need to make a count if function which will count the cell in a column if
the date in that column meets the following condition

TODAY()-A1>90

A1 in this formula represents the the Cell being referenced in a column of
60 dates I need to know how many of those dates are more than 90 days old.
Thanks in advance for any help

 

[T. Valko]

more than 90 days old.

Try this:

=SUMPRODUCT(--(A1:A60<TODAY()-90))

 

[Bernard Liengme]

=SUMPRODUCT(--(A1:A60<TODAY()-90))
best wishes

 

[Eduardo]

=SUMPRODUCT(--(A1:A60<TODAY()-90),--(A1:A60<>""))

 

[Gweduc]

Thanks for your help with this, it worked very well.

Sid

 

[T. Valko]

You're welcome. Thanks for the feedback!