If matching number, give me the years and months difference between dates

[Newbie73]

Hello everyone, my goal is a formula if S2 (and following values in S) matches any value in column B, then give me the difference in years and months from T2 and matching cell from column L belong to the matching value in B

Test spreadhseet in the link:

Test11.xlsx

1drv.ms

Did the first one in R2 manually as for example and any more question do let me know, don't think it's too hard but struggling to make it work.

Thanks!

 

[KOKOSEK]

But for values in col. B are couple different dates assigned in col. L? What then...
I get max date assign into particular ID:

Test11.xlsx
	B	C	D	E	F	G
1	ID	Date			ID	Date
2	1111	18/12/2023		5 years, 8 months	1111	09/04/2018
3	1111	18/10/2023		10 years, 4 months	2222	15/06/2012
4	1111	18/12/2023		10 years, 3 months	3333	18/09/2013
5	1111	18/10/2023		9 years, 11 months	4444	11/01/2014
6	2222	19/10/2022
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=LET(xMonths,DATEDIF(G2,MAXIFS(C:C,B:B,F2),"m"),xYears,DATEDIF(G2,MAXIFS(C:C,B:B,F2),"y"),xYears&" years, "&xMonths-(xYears*12)&" months")

 

[Newbie73]

But for values in col. B are couple different dates assigned in col. L? What then...
I get max date assign into particular ID:

Test11.xlsx
	B	C	D	E	F	G
1	ID	Date			ID	Date
2	1111	18/12/2023		5 years, 8 months	1111	09/04/2018
3	1111	18/10/2023		10 years, 4 months	2222	15/06/2012
4	1111	18/12/2023		10 years, 3 months	3333	18/09/2013
5	1111	18/10/2023		9 years, 11 months	4444	11/01/2014
6	2222	19/10/2022
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=LET(xMonths,DATEDIF(G2,MAXIFS(C:C,B:B,F2),"m"),xYears,DATEDIF(G2,MAXIFS(C:C,B:B,F2),"y"),xYears&" years, "&xMonths-(xYears*12)&" months")

Hello KOKOSEK and thank you for your time. Think you might be onto to something but not quite there. I will give some more background information, the B column values are all from the same unique ID that have procedures in different dates. The idea is to get years and months since they've joined (column G in your formula) in all the different procedures. So say in the example I've done 1111 which joined on the 09/04/2018 is 5y and 8 months on the procedure dated 18/12/2023. I would be 5y and 6 months for the previous procedure on the 18/10/2023

So each value on S only has one unique date of joining (column T) but have different or equal procedures dates. Do let me know if I didn't explained correctly.

 

[Newbie73]

Anyone please? Do let me know if anyone needs any more information or if I didn't explained it well enough.