Another hopefully more simple question. I have a cell "A9" referencing another sheet ='Truck 1'!F8 for the date entered, until a valid date is entered it display "19000100", is there an easy way to "blank" out this value until a current/valid date is entered? I did try conditional formatting hoping it would recognize the "19000100" but no luck there.