Calculate and display year and month

's Computer Specifications

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

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate Age Year Month & day	shailendra joshi	Microsoft Excel Misc	3	6th Sep 2008 03:33 PM
calculate year and month	=?Utf-8?B?bWljaGVsbGU=?=	Microsoft Excel Misc	9	23rd May 2008 08:54 AM
Calculate month & year in between two dates	Montu	Microsoft Excel Worksheet Functions	2	30th Dec 2007 04:45 AM
Calculate month & year in between two dates	Montu	Microsoft Excel Worksheet Functions	0	29th Dec 2007 08:19 AM
how to calculate total months from month/year	=?Utf-8?B?cGF0dGk=?=	Microsoft Excel Misc	1	8th Dec 2004 09:50 PM