Thanks Roger! works perfectly!
"Roger Govier" wrote:
Hi
Try
=DATEDIF(earlydate,latedate,"y")&" years
"&DATEDIF(earlydate,latedate,"ym")&" months"
For more information on the undocumented datedif function, take a look
at Chip Pearson's site
http://www.cpearson.com/excel/datedif.htm
--
Regards
Roger Govier
Stilla wrote:
Hello,
I'm using the =Yearfrac formula to calculate tenure. It returns the
result in years and fractions of years; e.g., 5.5 yrs.
Is there any way that the interval between two dates can be
calculated in years and months, so that I get 5yrs 6months?
thanks!