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.
