29 June 2013
One way to verify that a bona fide date is being entered into a cell is to use Data Validation.
The Data Validation formula being used, with cell E3 as the active cell in that selection, is =AND(ISNUMBER(E3),LEFT(CELL("format",E3),1)="D")
Full article: Validating an entry as a real date
