Hello there,
I have a list of person ID which looks like - 05058010843
First 6 numbers being date of birth.
Everything works well for people born before 2000.
If I try to apply same formula for ID: 20080426575
I get 112 years old..
I have a list of person ID which looks like - 05058010843
First 6 numbers being date of birth.
Everything works well for people born before 2000.
Code:
=INT(YEARFRAC(DATE(MID(B3,5,2),MID(B3,3,2),MID(B3,1,2)),DATE(2016,11,5))) & " years old"
If I try to apply same formula for ID: 20080426575
I get 112 years old..