calculating years/months with YEARFRAC?

[Stilla]

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!

[SteveG]

You could use the DATEDIF function.

=DATEDIF(A1,NOW(),"y") & " yrs, " & DATEDIF(A1,NOW(),"ym") & " months"

HTH,

Steve

[Roger Govier]

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!

[Stilla]

WOW! This is like magic!!! THANK YOU!!!

"SteveG" wrote:

>
> You could use the DATEDIF function.
>
> =DATEDIF(A1,NOW(),"y") & " yrs, " & DATEDIF(A1,NOW(),"ym") & " months"
>
> HTH,
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=514994
>
>

[Stilla]

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!
>
>
>