Replace null values in date column

Hi I have a column with promised delivery dates. The Excel sheet I'm importing this data from has some blank values for this column which are coming in as null values which is messing up my calculati...