formula for future date calculation based on cell value

[lakke2120]

Hello,
I have a calendar that I need to use for work that can calculate what the previous Wednesday and Friday is based on the date value in the previous column. The trick is that I need it to calculate which Wednesday and Friday is closest to being 10 days before. That's where I couldn't figure it out. Thanks in advanced

 

[steve the fish]

Test these. Think they work ok.

=A1-WEEKDAY(A1,13)-6
=A1-WEEKDAY(A1,15)-6