Dteectnig bdaly tpyed dtaa

One of the sad realities of being a data scientist is that you get handed a lot of awful datasets. If data has been manually entered, then it is really common to have typos, which can give the data the wrong type! You can use the IS functions to detect if your data has been correctly entered.

ISDATE() accepts a cell address and returns TRUE if that cell contains a date.