Issue:
I have a data point that is a date but is not in date format. I need the data point to be in day/month/year format.
I have had some luck using the following formula to parse the data but it is not getting me all the way.
=RIGHT(I2, LEN(I2)-4) &"-"& LEFT(I2,4)&""
If I use the above command I will get the following output 0201-1900 but I would like to have 01/02/1900 or even 01-02-1900
My data point looks like so 80999798 then I have to say =99999999-80999798 and I get 19000201.
If i click on the date format in excel I get ##### so I was looking for a formula that I could use to convert this to 01-02-1900
Any ideas?
Chris
Bookmarks