Calculate and display year and month

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
 
T

Teethless mama

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query the same table three times 0
find out specific month and year 1
FV when compounding occurs every 30 months 2
Expanding Date Formula 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Flag duplicate emails 1
Extract Month and year from Cell containing date, month, year & time 2
Calendar Logic: Recurring Dates 3

Top