#DATE EXPECTED Error

Gianni

I am trying to create an email reminder automation on one of our project schedules. We want the alert to go out 10 days before the line is set to be due (Finish Date Column). I created a date column to generate the reminder date (for the automation to use) by subtracting 10d from the finish date column. Some lines in this schedule are linked to predecessors in other sheets which means they start off blank until that predecessor is completed. When I subtract days from an empty cell I get a #DATE EXPECTED error which is just super annoying to look at constantly. Instead, it should just return a "-" or just be blank. =IFERROR will not fix this error message (I tried). Whats the workaround for this?

KPH

Hi @Gianni

I can't replicate what you are seeing, but would IF(ISBLANK) work for you?

=IF(ISBLANK([Finish Date]@row), "", Your formula to subtract 10 days)

or

=IF(ISBLANK([Finish Date]@row), "-", Your formula to subtract 10 days)

KPH

Hi Gianni,

Did this solve your problem?