Help me find function Datedif

V

ViestaWu

Dear everyone,

I try to use function Datedif in my worksheet, but I get a name error,
reason is that the function datedif doesn't exist in my function list. How
can I do?

Thanks,
Viesta
 
B

Bob Phillips

It doesn't show in the list, but it does exist. What does your formula look
like?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
V

ViestaWu

Hello,

Thank you!
Actually, I find I have made other mistake with it.

Datedif(A1,B1,D), I should add quotation mark to it.

BR
Viesta
 
B

Bob Phillips

It is the D that is returning the #NAME error. Your formula should be

=DATEDIF(A1,B1,"D")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

By the way, you could just as easily use

=B1-A1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top