Hoping someone can help.....
Running Excel 2003, do not seem to have quot;Workdayquot; function available in
function list?
TIA,
Sandi
Not to be a jerk... but have you tried typing =workday(your arguments
here) in a cell? This is from Help:
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days
exclude weekends and any dates identified as holidays. Use WORKDAY to
exclude weekends or holidays when you calculate invoice due dates,
expected delivery times, or the number of days of work performed.
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
How?
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
If necessary, follow the instructions in the setup program.
Syntax
WORKDAY(start_date,days,holidays)Make sure that the Analysis Toolpak function is installed.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
quot;RUSH2CROCHETquot; gt; wrote in message
...
gt; Hoping someone can help.....
gt;
gt; Running Excel 2003, do not seem to have quot;Workdayquot; function available in
gt; function list?
gt;
gt; TIA,
gt; Sandi
Toolsgt;Add-ins, check Analysis Toolpak
--
Kind regards,
Niek Otten
quot;RUSH2CROCHETquot; gt; wrote in message
...
| Hoping someone can help.....
|
| Running Excel 2003, do not seem to have quot;Workdayquot; function available in
| function list?
|
| TIA,
| Sandi
To: Dave O, Bob Phillips, Niek Otten:
Thanks for the quot;Analysis Tool Pakquot; reminder. I remembered having the
funtion previously, however, our organization recently updated to 2003
version, and I had not as yet installed that.
Thanks again!
Sandi
quot;Dave Oquot; wrote:
gt; Not to be a jerk... but have you tried typing =workday(your arguments
gt; here) in a cell? This is from Help:
gt;
gt; Returns a number that represents a date that is the indicated number of
gt; working days before or after a date (the starting date). Working days
gt; exclude weekends and any dates identified as holidays. Use WORKDAY to
gt; exclude weekends or holidays when you calculate invoice due dates,
gt; expected delivery times, or the number of days of work performed.
gt;
gt; If this function is not available, and returns the #NAME? error,
gt; install and load the Analysis ToolPak add-in.
gt;
gt; How?
gt;
gt; On the Tools menu, click Add-Ins.
gt; In the Add-Ins available list, select the Analysis ToolPak box, and
gt; then click OK.
gt; If necessary, follow the instructions in the setup program.
gt; Syntax
gt;
gt; WORKDAY(start_date,days,holidays)
gt;
gt;
Running Excel 2003, do not seem to have quot;Workdayquot; function available in
function list?
TIA,
Sandi
Not to be a jerk... but have you tried typing =workday(your arguments
here) in a cell? This is from Help:
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days
exclude weekends and any dates identified as holidays. Use WORKDAY to
exclude weekends or holidays when you calculate invoice due dates,
expected delivery times, or the number of days of work performed.
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
How?
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
If necessary, follow the instructions in the setup program.
Syntax
WORKDAY(start_date,days,holidays)Make sure that the Analysis Toolpak function is installed.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
quot;RUSH2CROCHETquot; gt; wrote in message
...
gt; Hoping someone can help.....
gt;
gt; Running Excel 2003, do not seem to have quot;Workdayquot; function available in
gt; function list?
gt;
gt; TIA,
gt; Sandi
Toolsgt;Add-ins, check Analysis Toolpak
--
Kind regards,
Niek Otten
quot;RUSH2CROCHETquot; gt; wrote in message
...
| Hoping someone can help.....
|
| Running Excel 2003, do not seem to have quot;Workdayquot; function available in
| function list?
|
| TIA,
| Sandi
To: Dave O, Bob Phillips, Niek Otten:
Thanks for the quot;Analysis Tool Pakquot; reminder. I remembered having the
funtion previously, however, our organization recently updated to 2003
version, and I had not as yet installed that.
Thanks again!
Sandi
quot;Dave Oquot; wrote:
gt; Not to be a jerk... but have you tried typing =workday(your arguments
gt; here) in a cell? This is from Help:
gt;
gt; Returns a number that represents a date that is the indicated number of
gt; working days before or after a date (the starting date). Working days
gt; exclude weekends and any dates identified as holidays. Use WORKDAY to
gt; exclude weekends or holidays when you calculate invoice due dates,
gt; expected delivery times, or the number of days of work performed.
gt;
gt; If this function is not available, and returns the #NAME? error,
gt; install and load the Analysis ToolPak add-in.
gt;
gt; How?
gt;
gt; On the Tools menu, click Add-Ins.
gt; In the Add-Ins available list, select the Analysis ToolPak box, and
gt; then click OK.
gt; If necessary, follow the instructions in the setup program.
gt; Syntax
gt;
gt; WORKDAY(start_date,days,holidays)
gt;
gt;
