Forum Discussion

Petra van looy's avatar
Petra van looy
Copper Contributor
May 27, 2018

need help with a formula

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 

Formulas & Functions
Need Help

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 28, 2018

    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,"=")