An Excel solution.
A while back, someone I know here in Wickenburg called me with an Excel question. He needed to calculate the date of the Wednesday least 90 days from an entered date.
So, for example, if he entered 2/14/2009 in a worksheet cell, he didn’t want 5/15/2009 (a Friday), which was 90 days later. He wanted 5/20/2009, which is the Wednesday at least 90 days after the date he entered.
The solution was to use nested IF statements to evaluate whether the day of the week 90 days after the entered date is a Wednesday. If it is, it uses that date. if it isn’t, it does the same evaluation for 91 days after the entered date. And then 92 days. And so on.
The spreadsheet I came up with can be downloaded here. This screenshot shows what it looks like. It has a lot of other stuff in it that I used to test the formula. Notes in the worksheet explain. I saved it just to share it here. You might find it useful if you have a similar need.
Just watch those parentheses.
This formula should advance to the next Wednesday when placed in cell C2 of your spreadsheet.
=IF(WEEKDAY(A2+90,1)<=4,4-WEEKDAY(A2+90,1)+A2+90,11-WEEKDAY(A2+90,1)+A2+90)
BR: Thanks for the shortened formula. I whipped up a quick and dirty solution for them and, when it worked, stopped tweaking. Just didn’t have the time to make it slim and trim. But a short formula is almost always a lot better than a long one if it does the same thing. Thanks for sharing.
This is great! You saved me an enormous amount of time – reaching into my desk drawer and pulling out my Excel book to figure it out on my own – you’re a lifesaver!