Originally Posted by Spencer101

I think you may have got the cells in your formula above wrong. A1 looks like a header cell rather than one that contains a date.

It's simple enough to make the error message not show using:

=IF(promised_date="","",promised_date-actual_date)

and just swap promised_date and actual_date with the correct cell refs and copy down.