I want to return a date that is the result of subtracting working days. For
example:

05/10/05 - 5 business days(m-f)= 05/03/05. Were 5/03/05 will be the
returned value when I enter the value 5 in a cell.

Thank you

Richard Herrera

Richard,
User workday function
Here A1 is the date, B1 is the number of days and C1 is where this function
goes.

=WORKDAY(A1,B1)

Alok Joshi

"Richard" wrote:

I want to return a date that is the result of subtracting working days. For
example:

05/10/05 - 5 business days(m-f)= 05/03/05. Were 5/03/05 will be the
returned value when I enter the value 5 in a cell.

Thank you

Richard Herrera

Thank you Alok for the quick response. However, when I put the assigned
values in the respected fields, I get a #NAME? value. So i thought maybe you
ment
=WEEKDAY(A1,B1), but I still get the samething.

I'm on version Excel 2003

Thank you
Richard


"Alok" wrote:

Richard,
User workday function
Here A1 is the date, B1 is the number of days and C1 is where this function
goes.

=WORKDAY(A1,B1)

Alok Joshi

"Richard" wrote:

I want to return a date that is the result of subtracting working days. For
example:

05/10/05 - 5 business days(m-f)= 05/03/05. Were 5/03/05 will be the
returned value when I enter the value 5 in a cell.

Thank you

Richard Herrera

Richard,

You may not have the Analysis Toolpak addin selected. Please go to the
Tools, Add-ins.. menu option select the Analysis Toolpak and OK. They you
will be able to use this function.

If you do not even see the Analysis Toolpak listed under the Addins
Available list then you may need to do as follows. (the following taken from
Excel Help on WORKDAY function)
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.

I tested this on XL2000 and it works.

Alok Joshi

"Richard" wrote:

Thank you Alok for the quick response. However, when I put the assigned
values in the respected fields, I get a #NAME? value. So i thought maybe you
ment
=WEEKDAY(A1,B1), but I still get the samething.

I'm on version Excel 2003

Thank you
Richard


"Alok" wrote:

Richard,
User workday function
Here A1 is the date, B1 is the number of days and C1 is where this function
goes.

=WORKDAY(A1,B1)

Alok Joshi

"Richard" wrote:

I want to return a date that is the result of subtracting working days. For
example:

05/10/05 - 5 business days(m-f)= 05/03/05. Were 5/03/05 will be the
returned value when I enter the value 5 in a cell.

Thank you

Richard Herrera

Ok, thank you much for your help!!

take care

Richard

"Alok" wrote:

Richard,

You may not have the Analysis Toolpak addin selected. Please go to the
Tools, Add-ins.. menu option select the Analysis Toolpak and OK. They you
will be able to use this function.

If you do not even see the Analysis Toolpak listed under the Addins
Available list then you may need to do as follows. (the following taken from
Excel Help on WORKDAY function)
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.

I tested this on XL2000 and it works.

Alok Joshi

"Richard" wrote:

Thank you Alok for the quick response. However, when I put the assigned
values in the respected fields, I get a #NAME? value. So i thought maybe you
ment
=WEEKDAY(A1,B1), but I still get the samething.

I'm on version Excel 2003

Thank you
Richard


"Alok" wrote:

Richard,
User workday function
Here A1 is the date, B1 is the number of days and C1 is where this function
goes.

=WORKDAY(A1,B1)

Alok Joshi

"Richard" wrote:

I want to return a date that is the result of subtracting working days. For
example:

05/10/05 - 5 business days(m-f)= 05/03/05. Were 5/03/05 will be the
returned value when I enter the value 5 in a cell.

Thank you

Richard Herrera