Some excel formula problem

[mzainims]

This is a non-VBA question.

The pic above is referred.
Suppose I have this numbers (840312107345; in B3) ; wanted to "extract" ONLY 840312 and re-arrange it to be into a date string as 12-03-84 (D3).
Then I'd like to calculate it in field AgeNow(E3) so that it will subtract NOW() & D3

How do I do this in excel worksheet formula in D3 & E3?

p.s...tried MID, REPLACE, LEFT...etc... none giving any correct answer.
Thanks in advance.

#stopthe pandemic

 

[DanteAmor]

How about:

varios 10may2020.xlsm
	A	B	C	D	E	F
1
2		DateID		Arrange	AgeNow
3		840312107345		12/03/1984	36
4
Hoja9

Cell Formulas
Range	Formula
D3	D3	=DATE(IF(LEFT(B3,2)+0<20,"20","19")&LEFT(B3,2),MID(B3,3,2),MID(B3,5,2))
E3	E3	=DATEDIF(D3,TODAY(),"y")

 

[mzainims]

Wow...tks....that a quickie.

It works....

....and how about if I "extract & convert" it into E3 without "placing it" into D3?.....meaning D3 doesn't exist.

 

[DanteAmor]

Try this

varios 10may2020.xlsm
	A	B	C	D	E	F
1
2		DateID			AgeNow
3		840312107345			36
4
Hoja9

Cell Formulas
Range	Formula
E3	E3	=DATEDIF(DATE(IF(LEFT(B3,2)+0<20,"20","19")&LEFT(B3,2),MID(B3,3,2),MID(B3,5,2)),TODAY(),"y")

 

[mzainims]

Coooollll.......tks again...you make my day...

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.