Need Formula to find the following Tuesday

[kyddrivers]

I am in need of a formula to return the date of the following Tuesday.

I could write an if formula to return the weekday and then add accordingly, but Im sure there is a cleaner more sexy way to do it.

Thanks for your help in advance!!

Example:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Key[/TD]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Following Tuesday after Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John[/TD]
[TD]7/19/16[/TD]
[TD]7/26/16[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Jack[/TD]
[TD]3/28/16[/TD]
[TD]3/29/16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Joe[/TD]
[TD]4/6/16[/TD]
[TD]4/12/16[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

There are lots of ways. Heres one:

=A1+CHOOSE(WEEKDAY(A1),2,1,7,6,5,4,3)

 

[kyddrivers]

Thank you so much for the quick and easy "fix".