workday date function

  • Thread starter Thread starter sjayar
  • Start date Start date
S

sjayar

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

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
(e-mail address removed)
 
Sounds like the standard Analysis Toolpak to me, not the VBA flavour.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
(e-mail address removed)
 
Back
Top