Question related to Convert into Date

[Excel]

Hello Everyone,

Suppose I have a EmpId data like

3710100951087 where -

37 is a Year of birth, so it should be come 1937

10 is a Month of birth

10 is a Date of Birth

So What formula should i write output should come in 10/10/1937 (dd/mm/yyyy) format?

Please help..??

Here is a attached file.

[#2 · Accepted solution]

@Excel 

That could be

=DATE(1900+LEFT(A2,2), MID(A2,3,2), MID(A2,5,2))

[#3]

It worked! Thank you so much Sir:smiling_face_with_smiling_eyes:

[#4]

@Excel , you are welcome