Help with dates

[DarthBrute]

I am trying to get a date to line up. First cell I input a date- Cell A1: 11/19/2015

In another cell, I need it to go to the next Wednesday. Lets call this Cell A2 (If the above date is a Wednesday then it should go to the next Wednesday.)

I did this: =WORKDAY(B23,4,0)

But I misunderstood the formula. It only adds 4 working days to it. I thought it was a series. (1=Sunday, 2=Monday, etc.)

Anyone got any ideas?

[FlameRetired]

Try entering in A2

Please Login or Register  to view this content.

PS

If you are not aware of it dates are numbers that Excel can format as dates for human eyes. Starting with day 1 (1/1/1900) each day is an increment of 1. Today is 12/3/2015. What Excel sees is 42341. This makes it convenient for calculating dates like yours.

[DarthBrute]

Yes but the date needs to go to the next Wednesday regardless of what date I put in there. Even if it is a Tuesday or Thursday. A2 needs to populate the calculated date as a Wednesday. This is for tracking inspection due dates. Updates on inspection corrections are due on Wednesday. Regardless of what day the inspection happens. Insepections are always during the week and never during the weekend.

[FlameRetired]

So if A1 is a Tuesday you need it to return the following day or the Wednesday of the following week?

[DarthBrute]

Yes. I was going to do an IF statement but I couldn't really find anything on specifying certain days of the week.

[alansidman]

=if(weekday(a1)=1,a1+10,if(weekday(a1)=2,a1+9,if(weekday(a1)=3,a1+8,if(weekday(a1)=4,a1+7,if(weekday(a1)=5,a1+6,if(weekday(a1)=6,a1+5,a1+4))))))

[FlameRetired]

Try this

Please Login or Register  to view this content.

[FDibbins]

your data is in A1, put this where you want the answer to be...
=A1+(7-(WEEKDAY(A1,2)-3))

[DarthBrute]

All 3 worked beautifully. Thank you very much for the help!

[FlameRetired]

You are welcome. Thank you for the feedback.

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)