I am trying to convert the numbers in the column D to date format. I have to use 5 help columns to get the date in the right date format as shown in the 6th help column. How Is it possible convert the number into date with a single formula compatible for 2007 version of excel.?
Shared the query on other forum as well.