This could be so easy but for some reason is not working out. My brain is burned.

I need a formula that would set recurring dates by day. For example if today is 11/05/2013 the next sheet on my spreadsheet should read 11/05/2013. Then the last sheet has to be linked but to show the next Wednesday only. So if this past Wednesday was 10/30/2013 now it has to show 11/6/2013. Please help and thanks in advance..