You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Gweduc" wrote in message
...
Thanks for your help with this, it worked very well.

Sid


"T. Valko" wrote:

more than 90 days old.

Try this:

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

--
Biff
Microsoft Excel MVP


"Gweduc" wrote in message
...
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()-A190

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