Try this:

=IF(OR($A5="",Q5=""),"",N5+LOOKUP(WEEKDAY(Q5),{1,2 ,3,4,5,6,7},{1,1,1,1,1,3,2}))

Biff

"slinger" wrote in message
...
I have the following formula set in one of my columns

=IF(OR(ISBLANK($A5),ISBLANK(Q5)),"",N5+1)

I need this to account for weekend days however and if Q5 falls on a
Friday
to add 3 (so that the formula returns a date for monday, and if Q5 falls
on a
Saturday to add 2 (again so that the formula returns a date for Monday.)
The
remainder of the formula needs to stay intact however, as there are other
functions that depend on it.

Any help would be greatly appreciated.

Thanks.