weekend to monday logic problem
I'm writing a timeline sheet and need to know the formula if a timeline ends on a Saturday/sunday to default to the following Monday IE:
inspection deadline is 10 days ( not workdays) but if it ends on a weekend /holiday it needs to default to the following Monday.
any help would be greatly appreciated
|