Ok, this is a strange way to format ime...2010-05-16T23:59:59.
I need some help pulling out the date so it formats in a normalized dd//mm/yyyy.
for example, =MID(Q4,FIND("-",Q4)+1,2) gets the day value. I need to concat the different values into a regular date.
Suggestions?