apgmin
Board Regular
- Joined
- Mar 1, 2010
- Messages
- 143
- Office Version
- 2013
- Platform
- Windows
Hello, Please help me
In cell A1 ; I have a date that is to be filled
In cell B1 ; I need the date to be 12 days after the date filed in A1 BUT such that if the end result is saturday or sunday, then it will add 1 or 2 days so that the end result is a monday
If the end result in Cell B1 is a date which is Monday to Friday then it not do the above addition
TO summarise the date in B1 should always be from Monday to Friday but after minimum 12 days from date A1
In cell A1 ; I have a date that is to be filled
In cell B1 ; I need the date to be 12 days after the date filed in A1 BUT such that if the end result is saturday or sunday, then it will add 1 or 2 days so that the end result is a monday
If the end result in Cell B1 is a date which is Monday to Friday then it not do the above addition
TO summarise the date in B1 should always be from Monday to Friday but after minimum 12 days from date A1
