In my spreadsheet, I have some inspection dates of some materials that I
have. I have to inspect these items on a "julian date" (30-day) interval.
For example:

A1 -- inspected date is 1 February 2006 (which is a Wednesday)
B1 -- Next inspection due date is 30 days from inspected date (may or may
not be
a Wedensday)

I have to inspect this item every 30 days, so I used the formula:

(In cell B1) "=A1+30"

This gave me 30 days after the inspected date, but I want the inspection to
show due on the Wednesday before the 30-day becomes due. Is there a way to
tell Excel to defer to the Wednesday immediately before the 30-day inpsection
is due?