top of page

How to deal with 'Date vs text'?

Example:

​

In the column "Date" the content is formatted as a date except for row 8 which is incorrectly formatted as text.

image.png

How to fix:

​

Check if a potential date is formatted as text. If this is the case, adjust the date type directly in the "Format cells" settings

bottom of page