See if this gives you an idea...
Your dates are color coded for a reason. Use that reason as the logic in a
formula. If they're color coded using conditional formatting, use the same
logic of the conditional formatting rule to write a formula.
--
Biff
Microsoft Excel MVP
"Nascarfan88" wrote in message
...
Wow...I agree...I'll figure something else.
Thanks very much for your help!
--
Keith
"T. Valko" wrote:
It can be done but it's complicated and it might not work the way you
think
it should work. I recommend not doing it that way.
See this:
http://www.cpearson.com/Excel/colors.aspx
--
Biff
Microsoft Excel MVP
"Nascarfan88" wrote in message
...
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