View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default Calculating new date by entering number of additional workdays

Hi

Ensure that you have the Analysis Toolpak loaded.
ToolsAddinsAnalysis Toolpak

then with startdate in A1, number of days to add in B1
=Workday(A1,B1)

Optionally you can include holidays. With a list of holiday adtes in C1:C20
=Workday(A1,B1,$C1:$C20)
--
Regards
Roger Govier

blswes wrote:
Would love some assistance with the following:

If I have a start date in a cell (A1), I am hoping to enter a number of
additional workdays into another cell (B1), resulting in a new date --
skipping weekends -- in a third cell (C1). Looking for the formula for C1.

If it helps, here's an example:
* Start date = 4/1/10 (which is a Thursday)
* Additional workdays = 5
* Solution = 4/7/10 (because it skipped the weekend)

Thanks in advance.