Display difference of two days as year, month and days
My question is that if it is possible that we can display the difference of two dates as Years, Months and days. For example
A B C
1 6/23/2002 11/30/2009 7 year 5 month 11 days
The actual difference between dates in B1 and A1 is 7 Years, 5 Months and 11 days. Normally we see that we can calculate difference in terms of years, or months or days. But I don't know if excel provides a function which can display the result as completely as I showed in C1.
If anyone knows, please help.
Thanks in advance.