Forum Discussion

CharmaineSilver's avatar
Qrew Member
5 years ago

Formula to convert part of number to date

Hi In South Africa we have Identity numbers which are 13 digits, the first 6 digits are your date of birth eg ID number is  8404130028085, then date of birth is 13 April 1984. What formula(s) can I ...