Maybe this:

=A1+30-CHOOSE(WEEKDAY(A1+30,2),0,0,0,0,0,1,2)


--
Biff
Microsoft Excel MVP


"Loren A - Huntley, Illinois" <Loren A - Huntley,
wrote in message
...
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.