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
|