Calculate and display year and month

  • Thread starter Thread starter kenlo
  • Start date Start date
K

kenlo

E.g. when Date1 - Date2 = 850 days (=2.33 years), is there a way to display
"2 years 4 months" within one cell? I have figured out the way to display in
2 separate cells.

Thanks
Ken
 
=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"
 
Back
Top