View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blswes blswes is offline
external usenet poster
 
Posts: 13
Default Calculating new date by entering number of additional workdays

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.