conditional sunday formula

[apgmin]

[TABLE="width: 681"]
<tbody>[TR]
[TD][TABLE="width: 681"]
<tbody>[TR]
[TD]COLUMN A COLUMN B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 681"]
<tbody>[TR]
[TD]START OF CLASSES[/TD]
[TD]6-Aug-18[/TD]
[/TR]
[TR]
[TD]EMAIL OF LIST OF PROMOTED STUDENTS OR NEW STUDENTS[/TD]
[TD]5-Aug-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In the above example Cell B2 has the formula B2-1
I want it to change to B2-1+1 if the value of B2-1 is sunday
or B2-1+2 if B2-1 is saturday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[nardagus]

Hello,

Excel 2016 (Windows) 32 bit

	A	B
Info	Term
START OF CLASSES
EMAIL OF LIST OF PROMOTED STUDENTS OR NEW STUDENTS

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]2018-08-06[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]2018-08-06[/TD]

</tbody>

Arkusz1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B3[/TH]
[TD="align: left"]=IF(WEEKDAY(B2-1,2)=7,B2,IF(WEEKDAY(B2-1,2)=6,B2+1,B2-1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Note that B2-1+1 can be wrote as B2, and B2-1+2 can be wrote as B2+1.

P.s. Oh. You need to adjust date to your regional format, as YYYY-MM-DD is in my country and your excel might not understand this.