=yearfrac(B2,D4)
b2 = =NOW() d4= 4/1/1990
and i get #name
Any ideaS?
=yearfrac(B2,D4)
b2 = =NOW() d4= 4/1/1990
and i get #name
Any ideaS?
Re: Yearfrac
Go to Tools>Add-ins and check Analysis Toolpak.
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?
Re: YEARFRAC Function/Formula Returning #NAME!
because most probably your cell is formatted as date...format the cell in number format
Don’t have an account yet? Register yourself now and be a part of our community!