May 23, 2020
I would like to change my date format in order to calculate the days between 2 dates but it is just not working.
the standard date format is dd-mmm-yy but files exported from one of the systems put it in yyyy-mmm-dd.
please assist.
Thank you
Grace
July 16, 2010
Hi Grace,
If you're referring to the Reported Date and Departure Date columns then these aren't even dates from Excel's perspective, they're text!
You have a couple of options for extracting the date:
1. If you want to add data to this table you can use this formula which can then be copied down for the remaining rows:
=DATE(LEFT(D8,2)+100,MONTH(DATEVALUE(LEFT(D8,9))),MID(D8,8,2))
2. If it's a one off task you can use Text to Columns to separate the date and time components into their own columns and then format the date correctly, choosing "YMD" in step 3 of the wizard.
Hope that helps.
Mynda
Answers Post
1 Guest(s)