Conditional formating dates

gurus,


I am trying to conditionally format a cell that when a date is entered, the cell is filled green. However, if the cell does not contain a date it should be no fill. Meaning, if the user enters a hyphen or NA in the cell, I don't want the cell to format to green.

Unfortunately in my sample spreadsheet, when a hyphen or even NA is entered in the cell, the cell fill is set to green. I cannot figure out the formula that only sets the fill to green when a date is entered.

I understand that excel translates dates to numbers, but I don't understand why a hyphen or even NA is also triggering the fill setting.

I have tried a couple of formulas in my sample to no avail. Please help and show my what I am doing wrong.

TIA,
Tim