Hi there all. I exported a file in a .CSV format, I have saved it as an excel file but im unable to convert the date field to a real date. I have numerous cells with the following data: Jan-07-2014 04:11:22 PM, Jan-13-2014 03:27:07 PM, Jan-14-2014 01:37:40 PM etc. I need to convert these cells to a date. In the end I need to count the number of days between 2 ranges of dates but i dont know how to do this unless they are in a date format.
I searched old posts & found =datevalue(a1) but it did not work. Any suggestions would be greatly appreciated.
thanks
I searched old posts & found =datevalue(a1) but it did not work. Any suggestions would be greatly appreciated.
thanks