Workdays Function

S

Shannon

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
 
B

Bob Phillips

=WORKDAY(A1,3)

WORKDAY is part of the Analysis Toolpak, check it is installed in
Tools>AddIns.

--
HTH

Bob Phillips

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

Dave Peterson

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

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