Excel Date/Day Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top