how to count date of birth using ID NO in Excel (formular)

[kaushera]

machan excel walin date of birth 1 Id no 1n count karanna puluwan formular 1k liyala dennako
bump 1k hari denna
thanks

 

[kaushera]

BUMP 1K WATH DEEPALLAKO

 

[navyseal]

Insert the ID Number in the Cell A1
=DATE(MID(A1,1,2),1,0)+(IF((MID(A1,3,3) +0) > 500,(MID(A1,3,3) +0) - 500,(MID(A1,3,3) +0)) - 1)