Formula to check if it is a DateIf your "date" in cell A1 is a text string and you want to check that it is valid, e.g.: '30 June 2012 is a valid date '31 June 2012 ...