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.
Cet exercice fait partie du cours
<cours>Google Sheets intermédiaire</cours>Instructions de l’exercice
- In cell
H2, check if the corresponding Date really is a date. - Copy the formula down the column.
Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice