View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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