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:

Key	Name	Date	Following Tuesday after Date
1	John	7/19/16	7/26/16
2	Jack	3/28/16	3/29/16
3	Joe	4/6/16	4/12/16

<tbody>
</tbody>

 

[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".