ExcelBanter - Calculate and display year and month

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculate and display year and month (https://www.excelbanter.com/excel-worksheet-functions/193732-calculate-display-year-month.html)

kenlo

Calculate and display year and month

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

Teethless mama

Calculate and display year and month

=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"

"kenlo" wrote:

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

All times are GMT +1. The time now is 07:06 AM.