B Barmaley Jul 8, 2003 #1 can someone explain why those functions are no in function list? and there are probably more of them thanks
can someone explain why those functions are no in function list? and there are probably more of them thanks
G Gord Dibben Jul 8, 2003 #2 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
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
