Return a date based on it being Monday, Thursday or Friday

[shina67]

Hi,

I have a spreadsheet that gets dates manually inputted into it.
What I need is a formula to return a date 7 days on from the manual input but has to be a Monday, Thursday or Friday.
I.E. Manual input is 1/10/19 or 2/10/19 I would want the returned date to be 10/10/19. Manual input 3/10/19 would return the date 10/10/19, manual input 4/10/19 returned date would be 11/10/19.

Hope this makes sense.
I have tried using a helper column with the function WEEKDAY in it but I am having some brain freeze.

Thanks in advance for any help.

 

[shknbk2]

Here's my formula. There may be better ones.

Book1
	A	B	C	D
1	Tue	10/1/2019	10/10/2019	Thu
2	Wed	10/2/2019	10/10/2019	Thu
3	Thu	10/3/2019	10/10/2019	Thu
4	Fri	10/4/2019	10/11/2019	Fri
5	Sat	10/5/2019	10/14/2019	Mon
6	Sun	10/6/2019	10/14/2019	Mon
7	Mon	10/7/2019	10/14/2019	Mon
8	Tue	10/8/2019	10/17/2019	Thu
9	Wed	10/9/2019	10/17/2019	Thu
10	Thu	10/10/2019	10/17/2019	Thu
11	Fri	10/11/2019	10/18/2019	Fri
12	Sat	10/12/2019	10/21/2019	Mon
13	Sun	10/13/2019	10/21/2019	Mon
14	Mon	10/14/2019	10/21/2019	Mon
15	Tue	10/15/2019	10/24/2019	Thu
16	Wed	10/16/2019	10/24/2019	Thu
17	Thu	10/17/2019	10/24/2019	Thu
Sheet1

Cell Formulas
Range	Formula
C1	=IF(OR(WEEKDAY(B1+7,14)<3,WEEKDAY(B1+7,14)=5),B1+7,IF(WEEKDAY(B1+7,14)>5,B1+7+3-WEEKDAY(B1+7,12),B1+7+3-WEEKDAY(B1+7,16)))

 

[Phuoc]

Or try this:

=WORKDAY.INTL(A1-1,1,"0110011")+7

 

[Phuoc]

A little shorter:

=WORKDAY.INTL(A1+6,1,"0110011")

​

 

[shina67]

Thanks for your replies. Both answers worked thank you very much