Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Kassie" wrote in message
...
Hi PhilS

I have searched some more, and came across the following very interesting
website, dealing with DateDif. Check it out, and maybe contact the author
for more advise. It appears that DateDif is a worksheet function,

available
in Excel, but which gives #NUM and #VALUE errors. I think your

installation
did not go well, hence the lack of the DateDif function, or else your
personal.xls sheet is in the wrong location?

Check out: http://www.cpearson.com/excel/datedif.htm


Intersting link. But it doesn't explain why you would get #NAME. You do get
this error if you tru to insert something like =NoSuchFunction() in a cell
because Excel doesn't recognize it as a function. I haven't followed this
thread but I woul like to know what happens if you use the function wizard
and insert DateDif using parameters that should work.

/Fredrik


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do I get a #Name error when I use the DateDif function? PhilS Excel Worksheet Functions 6 April 2nd 05 02:07 PM
datedif LWhite Excel Discussion (Misc queries) 1 February 16th 05 02:12 PM
The 'DATEDIF' Function is not listed on my Excel program. UOF Excel Worksheet Functions 7 January 5th 05 09:29 AM
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy Excel Worksheet Functions 7 December 11th 04 08:53 PM


All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"