Forum Discussion
Solved
How to convert date format from imported data?
I have a csv file exported from another program with a column of dates. Excel recognizes the data as dates but it converts them to the wrong format. The problem is the date March 27, 2017 shows u...
Hi Reuben,
The formula could be as
=DATE(DAY(A1)+2000,MONTH(A1),MOD(YEAR(A1),2000))
assuming all your dates are in 21st century.
If in A1 is 2027-03-17 (as date, not text) the formula returns 2017-03-27.
However, i'd start from second option
Hi Reuben,
The formula could be as
=DATE(DAY(A1)+2000,MONTH(A1),MOD(YEAR(A1),2000))
assuming all your dates are in 21st century.
If in A1 is 2027-03-17 (as date, not text) the formula returns 2017-03-27.
However, i'd start from second option
I've tried the import and it doesn't seem to work....