View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Add no. of days to a workday to get new workday?

Look in Help for details on the WORKDAY() function

"blswes" wrote:

Looking for a formula so I can add a number of workdays to an existing date
to get the new workday (i.e. existing date + workdays = new workday).

Here's an example:
1) Starting point: 4/15/10
2) Add: 4
3) Result: 4/21/10 (because it's 4 workdays after start date -- skipped
weekend)