account for weekends in date formula
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.
|