Hey Barry...
The reason that you are getting the Excel error is that you do not have the
WORKDAY function enabled... in order to use this function, you must enable
the Analysis ToolPak, generally the core installation of Excel does not
include all functions to be enabled, to take advantage of these extrat
capabilities, you need to select ToolsAdd Ins and then select the Analysis
Toolpak... this will eliminate the Excel error #NAME?...
--
Thanks for your help -
Joe Mac
"pdberger" wrote:
Barry --
What version of Excel are you using? When they went from 2000 to 2003, I
remember they changed some of the names. If you're using 2000, use help to
look at Date & Time functions.
HTH
"Barry Clark" wrote:
Hello PDBerger.
I have tried things like that and I only get #name? as a return.
--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409