Hi,
I have following number from which I am extracting date, ie. 2302989870009. First two digits are for the day of the month, 3rd and 4th numbers are for the month, and 5th trough 7th are numbers for year, in this case 23/02/1989.
I am using following formula to extract date from cell A2: DATE(MID(A2,6,2),MID(A2,3,2),MID(A2,1,2). The formula works fine until the year reaches 2000 or higher, ie 2302000870009. In that case I am getting year 1900 instead 2000.
Is there any formula to solve this problem.
Thanks in advance for any help.
Regards
Sasa