May 2009 Links

Links for the month of May.

Here are a few links of interest to the folks who read my books and articles or watch my training videos.

90 Days on a Wednesday

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.

90OnWednesdayThe 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.

April 2009 Links

Links for the month of April.

Here are a few links of interest to the folks who read my books and articles or watch my training videos.