Prev: Compare 1 cell to column of cells returning adjacent cells info?
Next: Can excel data be encrypted?
From: blswes on 15 Apr 2010 14:26
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)
From: Duke Carey on 15 Apr 2010 14:39
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)
 | 
Pages: 1
Prev: Compare 1 cell to column of cells returning adjacent cells info?
Next: Can excel data be encrypted?