You need to put quotes around the Y

=DATEDIF(A1,B1,"Y")

btw, you can use this instead

=DATEDIF(A1,NOW(),"Y")

or

=DATEDIF(A1,TODAY(),"Y")

if A1 is not a date excel recognizes it will return a value error

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"hellZg8" wrote in message
...
I actually did spell check so feburary was actually spelled correctly

I tried the =datedif(a1,b1,Y) got #name? in cell c1
a1= startdate
b1 =now()
c1=how many years in a number format with one decimal
place representing the months

eg.. 19 years 4 months = 19.4

formatting of the cells a1 & b1 are date with mmmm dd,yyyy
and c1 is number