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
|