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
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
Thank you sooooooooo very much......I knew you could solve this. GOOD JOB!!!!!!!!
Eternally grateful.....
Grace
