Years, Months, Days - Years, Months, Days

[tgamonv]

Hello,

If there a way to subtract Years, Months, Days from Years, Months, Days?

ie.
cell A1 has 2894
cell B1 has 7 years, 11 months, 3 days formula in the cell B1 is =DATEDIF(0,A1,"y") & " Years " & DATEDIF(0,A1,"ym") & " Months " & DATEDIF(0,A1,"md") & " Days "

cell A2 has 981
cell B2 has 2 years, 8 months, 7 days formual in cell B2 is =DATEDIF(0,A2,"y") & " Years " & DATEDIF(0,A2,"ym") & " Months " & DATEDIF(0,A2,"md") & " Days "

I would like to know the difference between B1 and B2 to show years months days in B3

Thank You!

 

[MARK858]

Is there any reason you can't subtract A2 from A1?

Book1
	A	B	C
1	2894	7 Years 11 Months 3 Days	5 Years 2 Months 27 Days
2	981	2 Years 8 Months 7 Days
Sheet1

Cell Formulas
Range	Formula
C1	C1	=DATEDIF(0,A1-A2,"y") & " Years " & DATEDIF(0,A1-A2,"ym") & " Months " & DATEDIF(0,A1-A2,"md") & " Days "
B1:B2	B1	=DATEDIF(0,A1,"y") & " Years " & DATEDIF(0,A1,"ym") & " Months " & DATEDIF(0,A1,"md") & " Days "

Although all the days are subjective as they are based on the dates from 1900 to1902 and 1900 to 1907

 

[tgamonv]

Is there any reason you can't subtract A2 from A1?

Book1
	A	B	C
1	2894	7 Years 11 Months 3 Days	5 Years 2 Months 27 Days
2	981	2 Years 8 Months 7 Days
Sheet1

Cell Formulas
Range	Formula
C1	C1	=DATEDIF(0,A1-A2,"y") & " Years " & DATEDIF(0,A1-A2,"ym") & " Months " & DATEDIF(0,A1-A2,"md") & " Days "
B1:B2	B1	=DATEDIF(0,A1,"y") & " Years " & DATEDIF(0,A1,"ym") & " Months " & DATEDIF(0,A1,"md") & " Days "

Although all the days are subjective as they are based on the dates from 1900 to1902 and 1900 to 1907

Guess i had a mental block and didn't think of that. That worked perfectly. Thank You!!!

 

[MARK858]

You're welcome