The only way your dates would not be regognised as dates/numbers is if there are NOT dates/numbers, but text that looks like a date. test with =isnumber(cell_ref)