countif cells (symbol) are red and if Today is after a certain date

KarineMul22_TPg

Hello,

I have tried many but this is the last one, still coming back with #INCORRECT

=COUNTIFS({2046 - DN COGS Work Package Tracker Range 2}, "Red", TODAY(0) >= DATE(2023, 9, 8))

I assume it's because there's no range in the second part of the formula but I can't figure out what other formula to use instead

Nick Korna

This should do it:

=IF(TODAY() >=DATE(2023, 9, 8), COUNTIF({2046 - DN COGS Work Package Tracker Range 2}, "Red"), "")

This will give you a blank if today is before that date, but you can substitute this by changing the false portion of the IF statement to another value/function.

Hope this helps, but if you've any problems or questions then just ask! 🙂

Nick Korna

This should do it:

=IF(TODAY() >=DATE(2023, 9, 8), COUNTIF({2046 - DN COGS Work Package Tracker Range 2}, "Red"), "")

This will give you a blank if today is before that date, but you can substitute this by changing the false portion of the IF statement to another value/function.

Hope this helps, but if you've any problems or questions then just ask! 🙂