why the DATEDIF error?

  • Thread starter Thread starter user
  • Start date Start date
U

user

DATEDIF is generating a #NAME? error; though, it appears in the help
pages, and I have the analysis toolpak loaded (Win 2000, Excel 2000).
Can someone help here?

I found how to do the following in "xlfdic01.xls":

I will use some simple math to determine periods in the form, "13 wk 4
d". Week and day units should suffice. Is it possible to get week and
day units output to a single cell?

Thank you.

Deric
 
Hi
can you post your complete formula. Maybe it's not the function name
but a parameter in this function. So just copy the formula directly
from your worksheet and post back
 
I have the analysis toolpak loaded

Not that it hurts having the ATP loaded but DATEDIF is a built-in function.

--
Jim Rech
Excel MVP
| DATEDIF is generating a #NAME? error; though, it appears in the help
| pages, and I have the analysis toolpak loaded (Win 2000, Excel 2000).
| Can someone help here?
|
| I found how to do the following in "xlfdic01.xls":
|
| I will use some simple math to determine periods in the form, "13 wk 4
| d". Week and day units should suffice. Is it possible to get week and
| day units output to a single cell?
|
| Thank you.
|
| Deric
|
 
Back
Top