Forum Discussion
Solved
Date format lost when downloading .csv file from online database
When downloading a .csv file from an online utility database, the Start and End Date columns lose their original date format (Ex: Jul 14, 2022). I've tried changing the format to "Short Date", "Long ...
It looks like the dates have been specified as the number of milliseconds since January 1, 1970.
Let's say start dates are in A2 and down, and end dates in B2 and down.
Enter the following formula in C2:
=DATE(1970,1,1)+A2/86400000
Format C2 as a date or as date plus time. You'll see the first start date.
Fill to the right to D2 to see the first end date.
Then fill down.
It looks like the dates have been specified as the number of milliseconds since January 1, 1970.
Let's say start dates are in A2 and down, and end dates in B2 and down.
Enter the following formula in C2:
=DATE(1970,1,1)+A2/86400000
Format C2 as a date or as date plus time. You'll see the first start date.
Fill to the right to D2 to see the first end date.
Then fill down.