Date Formula Result to not return a weekend day

[Carin]

I am trying to add 20 days (not work days) to a date and for the result to show Monday's date if the result falls on a Saturday or Sunday. I can easily perform this task using two cells/two formulas but am very interested in how to do this in one cell.

I tried if statements using weekday but can't make it work.

 

[Scott T]

does this do what you want?

Book1
	A	B
1	day	day plus 20
2	7/1/2019	7/22/2019
Sheet1

Cell Formulas
Range	Formula
B2	=IF(WEEKDAY(A2+20,1)=1,A2+21,IF(WEEKDAY(A2+20,1)=7,A2+22,A2+20))

 

[Carin]

Thank you so much! I was actually on the right track but for whatever reason didn't consider nesting the if statements. Again - thank you!!

 

[Eric W]

A couple of other options:

Book1
	A	B	C
1	day	day + 20
2	10-Jul	30-Jul	30-Jul
3			30-Jul
Sheet2

Cell Formulas
Range	Formula
B2	=A2+20
C2	=A2+CHOOSE(WEEKDAY(A2+20),21,20,20,20,20,20,20,22)
C3	=A2+20+MAX(0,3-WEEKDAY(A2+20,16))

I think the C2 formula is pretty clear. The C3 formula is shortest, but probably the most obscure.

 

[Tetra201]

Here is a yet shorter formula to try:

=WORKDAY(A2+19,1)