Help me find function Datedif
 

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

Help me find function Datedif
 

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)

"ViestaWu" wrote in message
...
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

Help me find function Datedif
 

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

"Bob Phillips" wrote:

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)

"ViestaWu" wrote in message
...
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

Help me find function Datedif
 

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)

"ViestaWu" wrote in message
...
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

"Bob Phillips" wrote:

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)

"ViestaWu" wrote in message
...
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

Help me find function Datedif
 

By the way, you could just as easily use

=B1-A1

--
HTH

Bob Phillips

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

"ViestaWu" wrote in message
...
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

"Bob Phillips" wrote:

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)

"ViestaWu" wrote in message
...
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