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.
This exercise is part of the course
Intermediate Google Sheets
Exercise instructions
- In cell
H2, check if the corresponding Date really is a date. - Copy the formula down the column.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise