I have a formula that returns a date 30 calendar days from a given date.
Example, cell A1 has 02/14/08. I want to add 30 days to this date and find
out what date that is but if that date is a Saturday or a Sunday, I want the
previous business day which is a Friday. I want to count all Saturdays and
Sundays during the 30 day cycle EXECPT if the 30th day is a Saturday or a
Sunday, I need to have a date returned that will back it up to the last
business day.

In other words, if today were February 15th and I had 30 calendar days to
complete my task, that would be March 16th, but since March 16th is a Sunday,
I need the formula to return the last business day (March 14th) on or before
day # 30.