Thanks much...That works great.
My dates are color coded, so how can I use the same formula, but only count
the dates in a specific color? Can this even be done?

Best regards
--
Keith


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(MASTER!AI5:AI5997=TODAY()-180),--(MASTER!AI5:AI5997<=TODAY()-91))

--
Biff
Microsoft Excel MVP


"Nascarfan88" wrote in message
...
I have a similar issue: I have a range of dates that I'm trackun using the
COUNTIF function based on the dates that are 91-180, 181-270, & 271-365,
days
old, based on the TODAY date. for the 90-180days, I'm using the
following,
but doesn't pan out:
=COUNTIF(MASTER!AI5:AI5997,"="&TODAY()-180),
(MASTER!AI5:AI5997,"<="&TODAY()-90)

Any help would be graetly appreciated!!

Keith