Forum Discussion

Merk182's avatar
Merk182
Copper Contributor
Sep 07, 2021
Solved

Excel Formula Nesting IF AND Functions if more than one cell blank

I am putting a tracking sheet together. On the sheet I have project "Due Dates" and also possible "Extensions" to that due date.    I think I'm ok calculating the time left -also OK with the condit...
excel
Excel on Mac
Formulas and Functions
  • DKoontz's avatar
    DKoontz
    Sep 07, 2021

    Merk182 

     

    Try:

    Just added an AND that states if both are blank, then return blank.

    =IF(AND(D5="",E5=""),"",IF(ISBLANK(E5),D5-TODAY(), E5-TODAY()))

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 07, 2021

Merk182 

You don't need a formula solution. Just copy the existing formula as far as column "Date Due" has dates.

Best way is converting the list into a table. Every time you add new data all formulas and formatting will extend to the new row.

And you can use MAX() instead of IF().

=MAX(Table1[@[Date Due]:[Extemsion]])-TODAY()

 

Resources