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.
Deze oefening maakt deel uit van de cursus
Intermediate Google Sheets
Oefeninstructies
- In cell
H2, check if the corresponding Date really is a date. - Copy the formula down the column.
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen