conditional sunday formula

[apgmin]

COLUMN A COLUMN B START OF CLASSES 6-Aug-18 EMAIL OF LIST OF PROMOTED STUDENTS OR NEW STUDENTS 5-Aug-18 <tbody> </tbody> <tbody> </tbody> 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

<tbody>
</tbody>

 

[nardagus]

Hello,

Excel 2016 (Windows) 32 bit

	A	B
1	Info	Term
2	START OF CLASSES	2018-08-06
3	EMAIL OF LIST OF PROMOTED STUDENTS OR NEW STUDENTS	2018-08-06

<tbody>
</tbody>

Arkusz1​

Worksheet Formulas Cell Formula B3 =IF(WEEKDAY(B2-1,2)=7,B2,IF(WEEKDAY(B2-1,2)=6,B2+1,B2-1)) <tbody> </tbody>

<tbody>
</tbody>

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.