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" |
=LET(d,DATEDIF(A1,A2,"m")/2,INT(d/12)&" years, "&MOD(d,12)&" months")
Hi Rick,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...
Excel Formula:=LET(d,DATEDIF(A1,A2,"m")/2,INT(d/12)&" years, "&MOD(d,12)&" months")