SOLVED

Question related to Convert into Date

%3CLINGO-SUB%20id%3D%22lingo-sub-2325742%22%20slang%3D%22en-US%22%3EQuestion%20related%20to%20Convert%20into%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325742%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3ESuppose%20I%20have%20a%20EmpId%20data%20like%3C%2FP%3E%3CP%3E%3CSTRONG%3E3710100951087%26nbsp%3B%3C%2FSTRONG%3Ewhere%20-%3C%2FP%3E%3CP%3E%3CSTRONG%3E37%3C%2FSTRONG%3E%20is%20a%20Year%20of%20birth%2C%20so%20it%20should%20be%20come%201937%3C%2FP%3E%3CP%3E%3CSTRONG%3E10%3C%2FSTRONG%3E%20is%20a%20Month%20of%20birth%3C%2FP%3E%3CP%3E%3CSTRONG%3E10%3C%2FSTRONG%3E%20is%20a%20Date%20of%20Birth%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20What%20formula%20should%20i%20write%20output%20should%20come%20in%20%3CSTRONG%3E10%2F10%2F1937%20%3C%2FSTRONG%3E(dd%2Fmm%2Fyyyy)%20format%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2325742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325876%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Convert%20into%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DDATE(1900%2BLEFT(A2%2C2)%2C%20MID(A2%2C3%2C2)%2C%20MID(A2%2C5%2C2))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325894%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Convert%20into%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325894%22%20slang%3D%22en-US%22%3EIt%20worked!%20Thank%20you%20so%20much%20Sir%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2326044%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20Convert%20into%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

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.

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Zan_Hanifee 

That could be

=DATE(1900+LEFT(A2,2), MID(A2,3,2), MID(A2,5,2))
It worked! Thank you so much Sir

@Zan_Hanifee , you are welcome