Workdays Function
 

I am trying to create a formula that will take the date I enter (in one cell)
and add 3 Workdays to this.

Ie. in one cell I will enter 10/06/2006 and in the next cell I want it to
automatically fill in 10/11/6 (3 business days).

Is this possible?
Any help would be greatly appreciated.
Thanks,
Shannon

Workdays Function
 

=WORKDAY(A1,3)

WORKDAY is part of the Analysis Toolpak, check it is installed in
ToolsAddIns.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Shannon" wrote in message
...
I am trying to create a formula that will take the date I enter (in one
cell)
and add 3 Workdays to this.

Ie. in one cell I will enter 10/06/2006 and in the next cell I want it to
automatically fill in 10/11/6 (3 business days).

Is this possible?
Any help would be greatly appreciated.
Thanks,
Shannon

Workdays Function
 

Turn on (or install) the analysis toolpak
Tools|Addins

Then look at =workday() in Excel's help.



Shannon wrote:

I am trying to create a formula that will take the date I enter (in one cell)
and add 3 Workdays to this.

Ie. in one cell I will enter 10/06/2006 and in the next cell I want it to
automatically fill in 10/11/6 (3 business days).

Is this possible?
Any help would be greatly appreciated.
Thanks,
Shannon

--

Dave Peterson