YEARFRAC Function/Formula Returning #NAME!

pinehead · Feb 27th 2006

=yearfrac(B2,D4)

b2 = =NOW() d4= 4/1/1990

and i get #name

Any ideaS?

Dave Hawley · Feb 27th 2006

Re: Yearfrac

Go to Tools>Add-ins and check Analysis Toolpak.

pinehead · Feb 27th 2006

Re: YEARFRAC Function/Formula Returning #NAME!

That worked but instead of saying the amount of years till maturity it just displayed

1/15/1900

Suggestions?

pangolin · Feb 27th 2006

Re: YEARFRAC Function/Formula Returning #NAME!

because most probably your cell is formatted as date...format the cell in number format

Participate now!