In some sales files the date is presented as text in the UTC (coordinated universal time) format.
Example: 2016-02-29 15:47:21
To convert this text to a date use the formula: =DATEVALUE(cell). This changes the text to a numeric value of the date.
To change the numeric value to a date format the cell as a date.