Calculate end date based on in between workdays

[Roli001]

Hi,

I have a sheet where I have a start date and a number of work days to add to that start date. On that sheet I also have information if i should count Saturday and/or Sunday as workdays. I am looking for a formula to calculate the end date based off of the total days to add to the start date and if Saturday and/or Sunday should be treated as workdays.

Here is an example with sample results:

Excel 2010
	A	B	C	D	E
2	Start Date (Tuesday)	8/4/2015	8/4/2015	8/4/2015	8/4/2015
3	Work Days	10	10	10	10
4	Include Saturday	NO	YES	YES	NO
5	Include Sunday	NO	YES	NO	YES
6
7	Result	8/18/2015	8/14/2015	8/15/2015	8/16/2015
8
9
10	Start Date (Tuesday)	8/4/2015	8/4/2015	8/4/2015	8/4/2015
11	Work Days	20	20	20	20
12	Include Saturday	NO	YES	YES	NO
13	Include Sunday	NO	YES	NO	YES
14
15	Result	9/1/2015	8/24/2015	8/27/2015	8/27/2015
Sheet1

Thanks for your help.

 

[Bagharmin]

You could take a look at the WORKDAY.INTL function in Excel. That sounds like it would work well.

 

[Roli001]

Thank You!

Never used this function before.