Formula to convert a year to half

[mdnsh]

Good day,

Please help me to write a formula for the following condition.

26-Nov-2021 to 19-Oct-2023 = 1 Years, 10 Months.

The result should be 0.5 Years, 5 Months.

Thanks in advance.

 

[kevin9999]

Book1
	A
1	26-Nov-2021
2	19-Oct-2023
3	0.5 years, 5 months
Sheet1

Cell Formulas
Range	Formula
A3	A3	=DATEDIF(A1,A2,"y")/2&" years, "&DATEDIF(A1,A2,"ym")/2&" months"

 

[Rick Rothstein]

To me, it would make more sense to report the difference as "0 years, 11 months" instead of "0.5 years, 5 months". If you agree, here is the formula to do that...

=LET(d,DATEDIF(A1,A2,"m")/2,INT(d/12)&" years, "&MOD(d,12)&" months")

 

[mdnsh]

Hi Kevin,

Thanks a lot.

 

[kevin9999]

Glad we could help & thanks for the feedback

 

[mdnsh]

To me, it would make more sense to report the difference as "0 years, 11 months" instead of "0.5 years, 5 months". If you agree, here is the formula to do that...

=LET(d,DATEDIF(A1,A2,"m")/2,INT(d/12)&" years, "&MOD(d,12)&" months")

Hi Rick,

Yes, it makes sense. Thanks for your time looking into this.