View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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