Datedif, Workday etc.

[Barmaley]

can someone explain why those functions are no in function list? and there
are probably more of them

thanks

 

[Gord Dibben]

Barmaley

Datedif is not in the Function list except in XL2000.

Other Functions such as WORKDAY, EDATE, NETWORKDAYS and many others will
appear in the list only if the Analysis ToolPak Add-in is loaded.

For a complete listing and description of all Functions check out the Norman
Harker downloadable workbook of Functions from Debra Dalgleish's site.

http://www.contextures.on.ca/functions.html

Also Peter Noneley's Function list and examples workbook from..

http://homepage.ntlworld.com/noneley/

Gord Dibben Excel MVP - XL97 SR2 & XL2002