=yearfrac(B2,D4) b2 = =NOW() d4= 4/1/1990 and i get #name Any ideaS?
Feb 27th 2006 #3 Re: YEARFRAC Function/Formula Returning #NAME!That worked but instead of saying the amount of years till maturity it just displayed1/15/1900Suggestions?
Feb 27th 2006 #4 Re: YEARFRAC Function/Formula Returning #NAME!because most probably your cell is formatted as date...format the cell in number format