Hi;
I need your help on the following scenario, I have a spreadsheet where I have column B structured to highlight in red items that have been opened more than 14 days, to highlight in orange items that have been opened more than 7 days but less than 14, and in yellow to highlight cases that have been opened more than 3 days but less than 7.
What I've been trying to do without success is to count this events, I want to know/count (in individual cells) how many of this are red, how many of this are orange and how many are yellow that of course updates automatically as you enter or delete data. I've been trying to use COUNTIF without success, this are my formulas which all are returning to 0 (which is not ok).
<today()")
<today()")
<today()")
=COUNTIF(B2:B2000, "$B2+14<TODAY()")
=COUNTIF(B2:B2000, "$B2+7<TODAY()")
=COUNTIF(B2:B2000, "$B2+3<TODAY()")
[/IMG]</today()")
</today()")
</today()")
I need your help on the following scenario, I have a spreadsheet where I have column B structured to highlight in red items that have been opened more than 14 days, to highlight in orange items that have been opened more than 7 days but less than 14, and in yellow to highlight cases that have been opened more than 3 days but less than 7.
What I've been trying to do without success is to count this events, I want to know/count (in individual cells) how many of this are red, how many of this are orange and how many are yellow that of course updates automatically as you enter or delete data. I've been trying to use COUNTIF without success, this are my formulas which all are returning to 0 (which is not ok).
<today()")
<today()")
<today()")
=COUNTIF(B2:B2000, "$B2+14<TODAY()")
=COUNTIF(B2:B2000, "$B2+7<TODAY()")
=COUNTIF(B2:B2000, "$B2+3<TODAY()")
</today()")
</today()")
Last edited: