need help with a formula

[Petra van looy]

Hello,

I need help with a formula in Excel. I need to count the Overdue deadlines in a sheet. A deadline is "Overdue" when the date Today is later or when the cell next to it is still empty after this date.

So it nee to be someting like this:

IF A3 > then TODAY

AND B3 = EMPTY

THEN COUNT = 1 in C3 

[#2]

Hi Petra,

Formula for C3 could be

=IF((A3>TODAY())*ISBLANK(B3),1,"")

or simply

=(A3>TODAY())*ISBLANK(B3)

if you use 1/0 in C3

Above is for the combination of A3 and B3. If to count all overdue in for your columns when like

=COUNTIFS($A$3:$A$200,">"&TODAY(),$B$3:$B$200,"=")