Add no. of days to a workday to get new workday?

's Computer Specifications

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)

's Computer Specifications

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)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding days to the WORKDAY function	tr2yhb	Microsoft Excel Discussion	1	12th Feb 2011 12:05 PM
Calculate next workday after adding calendar days to date in cell	Darrell	Microsoft Excel Worksheet Functions	13	7th May 2010 12:04 AM
WOrkday function - change working days	=?Utf-8?B?QXNodXRvc2g=?=	Microsoft Excel Worksheet Functions	2	7th Oct 2006 04:16 PM
Is there a WorkDay() type function that count all days except tho.	=?Utf-8?B?RGFyayBTa3Vuaw==?=	Microsoft Excel Worksheet Functions	8	15th Feb 2005 08:37 PM
Re: Workday	hgrove	Microsoft Excel Worksheet Functions	0	21st Jul 2004 07:26 PM