Bob

Not sure if I misunderstand here, but is the OP not wanting the function to
work in code. He can get it working on a worksheet but it throws an error
when trying it in code?

Nick

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Bob Phillips" wrote in message
...
Sounds like the standard Analysis Toolpak to me, not the VBA flavour.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nick Hodge" wrote in message
...
sjayar

You will need to install and enable the analysis toolpak FOR VBA as the
function WORKDAY is part of the standard analysis toolpak

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"sjayar" wrote in
message ...

Hi All,
I have a worksheet with date time picker,2 textbox and a command
button.

on click of this button textbox2 should get filled with date

like:......................
Assume
1. cell A1 contains date(10/11/2005)
2. B1 contains some numberic value(2)
3. C1 = workday(A1, B1) will be give serial number which after
formatting to date type gives me 12/11/2005


is there a way to implement the same steps in my macro.
if i use worday() i get sub or function not defined

Plz let me know how to do this.


--
sjayar
------------------------------------------------------------------------
sjayar's Profile:
http://www.excelforum.com/member.php...o&userid=28435
View this thread:
http://www.excelforum.com/showthread...hreadid=484205