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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Forecasting Dates Out to the Day 3
Dates 3
CALENDAR CREATION 1
CONVERT A DATE TO A DAY 3
Countif Function?? 3
Combine day text and date problems 6
Query from day of week 3
Show Data In Report On One Row Instead Of In A Column 2

Back
Top