|
workday date function
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 |
workday date function
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 |
workday date function
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 |
| All times are GMT +1. The time now is 10:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com