#INVALID DATA TYPE

Pskidmore

Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is there any way to make that go away and just stay blank until a Date assigned is entered? Thanks

 

JamesR

Use an IF statement to check that the Date Assigned cell has a date in it, if it has then the formula, otherwise "".

=IF(ISDATE([Date Assigned]88),WORKDAY([Date Assigned]88 .......,"")