Hi Everyone,
I will be great-full if someone can help me with the formula or macro on this.
We have tasks assigned to each department with the due date. The tasks have been distributed in the order that they need to be completed. This is done so that each department completes the tasks in the specified time.
For example:
Project Brief (Sales) Due date 15/08/2019, Days before project delivery -127
Project Costing (Finance) Due date 20/09/2019 -91
Project Approval (Management) Due date 18/10/2019 -63
Order received (Sales) Due date 30/10/2019 -51
Goods ordered (Logistics) Due date 10/11/2019 -40
Stock received (Logistics) Due date 30/11/2019 -20
Payment received (Finance) Due Date 10/12/2019 -10
Stock supplied (Transportation) Due Date 20/12/2019 0
Project reporting (Sales) Due Date 30/01/2020 +41
Project delivery / completion dates is based on when the stock needs to be supplied to the customer. For example if the project delivery date is 20/12/2019. We should have received payment 10 days before this date and stock from supplier 20 days before so that we can achieve the target date.
Each project has different stock supplied date and if for example, supplied date is 20/Feb most of the tasks fall into Xmas period between 21/Dec/2019 to 10/Jan/2020. Is it possible for someone to do a formula or macro that all the dates falling in between Xmas holiday period automatically moved before that and keep same number of days difference between the tasks.
I will be great-full if someone can help me with the formula or macro on this.
We have tasks assigned to each department with the due date. The tasks have been distributed in the order that they need to be completed. This is done so that each department completes the tasks in the specified time.
For example:
Project Brief (Sales) Due date 15/08/2019, Days before project delivery -127
Project Costing (Finance) Due date 20/09/2019 -91
Project Approval (Management) Due date 18/10/2019 -63
Order received (Sales) Due date 30/10/2019 -51
Goods ordered (Logistics) Due date 10/11/2019 -40
Stock received (Logistics) Due date 30/11/2019 -20
Payment received (Finance) Due Date 10/12/2019 -10
Stock supplied (Transportation) Due Date 20/12/2019 0
Project reporting (Sales) Due Date 30/01/2020 +41
Project delivery / completion dates is based on when the stock needs to be supplied to the customer. For example if the project delivery date is 20/12/2019. We should have received payment 10 days before this date and stock from supplier 20 days before so that we can achieve the target date.
Each project has different stock supplied date and if for example, supplied date is 20/Feb most of the tasks fall into Xmas period between 21/Dec/2019 to 10/Jan/2020. Is it possible for someone to do a formula or macro that all the dates falling in between Xmas holiday period automatically moved before that and keep same number of days difference between the tasks.