You are better off in the Excel group forums for reponses to Excel related
Questions. However, I believe this will work for you:
=RC[-1]+(7-WEEKDAY(RC[-1],1))+4
"Chris waller" <Ch*********@discussions.microsoft.comwrote in message
news:3E**********************************@microsof t.com...
>I have a column of dates (A) on an Excel Spreadsheet. I would like a
formula
that gives me the Wednesday following. If the date is a Wednesday I would
like it to show me the Wednesday of the following week.