I want to count past due tasks using 2 date columns.
I'm trying to count overdue tasks by using 2 different date columns. I'm currently using this formula , =COUNTIFS([Hardware Actual Construction NTP]:[Hardware Actual Construction NTP], <[Hardware Planned Construction NTP]:[Hardware Planned Construction NTP])
However, whatever dates get put into the columns the count is always 0 and I'm not sure what I'm doing wrong. I'm hoping I can get it to count if the Actual start date is later than the projected start date.
Help Article Resources
Check out the Formula Handbook template!