Days Remaining formula w/ error messages for missing fields

Options

Good Afternoon,

I have a sheet with Start Date , Due Date and Days Remaining Columns. I am to populate the Days Remaining Field using

=[Due Date]@row - TODAY()


I wanted to have a message display in place of the Days Remaining if the Start or Due date are missing. The messages work if I replace the previous formula with

=IF(ISBLANK([Start Date]@row), "Start Date Missing", IF(ISBLANK([Due Date]@row), "Due Date Missing"))


But I can't figure out how to combine the two. I have tried everyway I can think of but all I get a syntax errors.

Thank You

Best Answer

Answers