| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Datedif function | Excel Discussion (Misc queries) | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| rounding the DATEDIF function | Excel Discussion (Misc queries) | |||
| how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
| Why do I get a #Name error when I use the DateDif function? | Excel Worksheet Functions | |||
Linear Mode
