May 05 2021 03:43 AM
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.
May 05 2021 04:06 AM
SolutionMay 05 2021 04:13 AM
May 05 2021 04:06 AM
SolutionThat could be
=DATE(1900+LEFT(A2,2), MID(A2,3,2), MID(A2,5,2))