How to do formula to autocalculate age from Identity Card Number?
e.g 110802018888 means the 1st 6 numbers is the birthday = 02/08/2011
e.g. 090802018888 means the 1st 6 numbers is the birthday = 02/08/2009.
e.g 980802018888 means the 1st 6 numbers is the birthday = 02/08/1998
I tried to do the formula, but not valid for year after 2000 or before 2000
=IF(LEN(K3)=11,12-LEFT(K3,1),(IF(LEN(K3)=12,112-LEFT(K3,2)))).
The file is uploaded.
Thank you very much.
Bookmarks