Next Workday where Fri and Sat are Weekends

[animas]

Using formulas how can I calculate next workday where friday and saturday are weekends? Note that I also has a list of holidays.

Thanks.

 

[schielrn]

Try:

Excel Workbook
	V
11	2-Aug
12	3-Aug
13	4-Aug
14	5-Aug
15	8-Aug
16	9-Aug
Data Check

Cell Formulas
Range	Formula
V12	=WORKDAY(V11+1,1)-1
V13	=WORKDAY(V12+1,1)-1
V14	=WORKDAY(V13+1,1)-1
V15	=WORKDAY(V14+1,1)-1
V16	=WORKDAY(V15+1,1)-1

=workday(A1+1,1,holidays)-1

Hope that helps.

 

[AlphaFrog]

To expand on schielrn's idea, you would have to offset the holiday list by one day as well to get them to work properly


<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:202.4px;" /><col style="width:24px;" /><col style="width:211.2px;" /><col style="width:208.8px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-weight:bold; text-align:center; ">Next work day</td><td style="font-weight:bold; "> </td><td style="font-weight:bold; text-align:center; ">Holidays</td><td style="font-weight:bold; text-align:center; ">Holidays+1</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">Wednesday, August 11, 2010</td><td > </td><td style="text-align:right; ">Tuesday, August 17, 2010</td><td style="text-align:right; ">Wednesday, August 18, 2010</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">Thursday, August 12, 2010</td><td > </td><td style="text-align:right; ">Wednesday, August 18, 2010</td><td style="text-align:right; ">Thursday, August 19, 2010</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">Sunday, August 15, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">Monday, August 16, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">Thursday, August 19, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">Sunday, August 22, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">Monday, August 23, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">Tuesday, August 24, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">Wednesday, August 25, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">Thursday, August 26, 2010</td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">Sunday, August 29, 2010</td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >D2</td><td >=C2+1</td></tr><tr><td >A3</td><td >=WORKDAY(A2+1,1,$D$2:$D$3)-1</td></tr><tr><td >D3</td><td >=C3+1</td></tr><tr><td >A4</td><td >=WORKDAY(A3+1,1,$D$2:$D$3)-1</td></tr><tr><td >A5</td><td >=WORKDAY(A4+1,1,$D$2:$D$3)-1</td></tr><tr><td >A6</td><td >=WORKDAY(A5+1,1,$D$2:$D$3)-1</td></tr><tr><td >A7</td><td >=WORKDAY(A6+1,1,$D$2:$D$3)-1</td></tr><tr><td >A8</td><td >=WORKDAY(A7+1,1,$D$2:$D$3)-1</td></tr><tr><td >A9</td><td >=WORKDAY(A8+1,1,$D$2:$D$3)-1</td></tr><tr><td >A10</td><td >=WORKDAY(A9+1,1,$D$2:$D$3)-1</td></tr><tr><td >A11</td><td >=WORKDAY(A10+1,1,$D$2:$D$3)-1</td></tr><tr><td >A12</td><td >=WORKDAY(A11+1,1,$D$2:$D$3)-1</td></tr></table></td></tr></table>

 

[schielrn]

Yes sorry I forgot about that. Thanks for adding that.

 

[animas]

Thank you. Working great.