Formula to return the Date of the wednesday of the next week

[Melvinrobb]

Hi

I have a list of dates in column D. In the actual file the dates are completely random. I have them in order for simplicity sake here.
I am looking for a formula to use in column H that will return the Wednesday of the NEXT week. I put in an example of what i want the formula to return in the first 14 lines.
I could come up with a formula using MULTIPLE helper columns, but i figured there might be a cleaner way that what I had envisioned.

Thanks in advance!

[alansidman]

Try this in Cell H1 and copy down

=D1+CHOOSE(WEEKDAY(D1),10,9,8,7,6,5,4)

Alan

Edit: There is no file attached to review.