Re: months calculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: daddylonglegs <daddylonglegs.2a5snp_1151576707.0537@xxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 29 Jun 2006 05:23:01 -0500

Bob Phillips Wrote:

Can't see where you get 0.6 from, as that is only 3 months by my calcs,
which is .25, but maybe this helps

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A1,TODAY(),"ym")/12

Couldn't you get the same result with

=DATEDIF(A1,TODAY(),"m")/12

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486
View this thread: http://www.excelforum.com/showthread.php?threadid=556785

.

Follow-Ups:
- Re: months calculation
  - From: Bob Phillips

References:
- Re: months calculation
  - From: Bob Phillips

Prev by Date: Re: Trying to find sales figures of certain products.
Next by Date: Re: months calculation
Previous by thread: Re: months calculation
Next by thread: Re: months calculation
Index(es):
- Date
- Thread