count overdue dates and ignore blanks using countifs
So far I have this and spent 1/2 hour plus trying to understand isblank and error trapping in the forums but can't quite knit everything together.
=countifs(cc:cc,"120802",[Due Date], <=TODAY)
Background - cc column I want to show only 120802 and for the Due Date column only count those dates < today's date. My problem is not all tasks have allocated dates, so need to ignore.
I thought this would have been straightforward, but I am missing something.Thanks in advance Paul
Help Article Resources
Check out the Formula Handbook template!