Advanced date find formula ( by day of week )

[Hatricke]

I need some help building the following formula.

User would enter a date in a cell, and the related cell would return the first Wednesday at least 30 days away.

I.E Date plus 30 days, and if that happens to be a Wed post it, if not post the date of the next Wed that will come up.

I have it in my mind it would need to be something to the affect of Date + 30 convert using Weekday function then a series of either True/false or if/then statements to move forward until the Wed is reached, and then re-converted to date.

Hope that explains it, and thanks in advance for any helpful advice anyone has.

[daddylonglegs]

If you want to find the first Wednesday on or after a date in A1 then the formula would be

=A1+7-WEEKDAY(A1+3)

In this case you want A1 to actually be A1+30 so the formula becomes

=A1+30+7-WEEKDAY(A1+30+3)

which you can simplify to

=A1+37-WEEKDAY(A1+5)