If Blank and Workday in the same cell?

KristiTRUSD

Hello,

I'd like a Due Date cell to populate based on a date being entered into another Date Completed cell, and add 35 days. That formula works fine: =WORKDAY([Date Completed]44, +35)

The issue I'm running into is that I'd like the Due Date cell in row 51 to stay blank if there isn't a date entered into the Date Completed cell in row 44, instead I get #INVALID DATA TYPE.

I know there is an ISBLANK function that works, and I did try that, but I can't seem to get both functions to work at the same time in the cell. I'm still pretty new to this and I always have struggled a bit with functions/formulas in Excel as well.

I'd love any help I can get.

Sameer Karkhanis

Either should work,

=IFERROR(WORKDAY([Date Completed]44, 35), "")

=IF(ISBLANK([Date Completed]44), "", WORKDAY([Date Completed]44, 35))

Sameer Karkhanis

Either should work,

=IFERROR(WORKDAY([Date Completed]44, 35), "")

=IF(ISBLANK([Date Completed]44), "", WORKDAY([Date Completed]44, 35))

KristiTRUSD

Thank you so much! That worked beautifully!