calculating years/months with YEARFRAC?

's Computer Specifications

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!

's Computer Specifications

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

's Computer Specifications

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!

's Computer Specifications

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

's Computer Specifications

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating Years and Months Between Dates	Tassy Anne	Microsoft Excel Misc	2	6th Feb 2009 03:44 PM
Calculating Age in Years and months in a form	Jessica	Microsoft Access	2	1st Dec 2008 12:24 AM
Calculating age in years and months	=?Utf-8?B?Uk1DREQ5OTc=?=	Microsoft Access	10	10th Sep 2007 02:39 AM
Calculating Years, Months & Days	Phillip Holdsworth	Microsoft Excel Worksheet Functions	3	23rd Apr 2004 01:11 PM
calculating years and months between 2 dates	rajgopal	Microsoft Excel Worksheet Functions	2	15th Apr 2004 11:01 PM