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
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()))

DKoontz

Iron Contributor

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()))

Merk182

Copper Contributor

Sep 07, 2021

Thank you - worked perfectly. I thought I had to use AND - just my syntax was screwing up and it didn't work.

DKoontz
Iron Contributor
Sep 07, 2021
Glad I could help!

Forum Discussion

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

Resources