Xmas holiday period adjustment.

Hi Everyone,

Am new here and 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.

Each project has different stock supplied date and if for example, supplied date is 20/Feb then 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.

Please see some examples in picture.

I have had conditional formating on column to highlight dates between 19-Dec to 10-Jan and that worked fine. If I change delivery date it will highlight Xmas holiday period. No other holidays need to be considered.

Thanks in advance.

Table_Example01.png

Hi AliGW,

Please see sample date excel file and column O to T is what we are looking for in the result.

Many thanks,

Hi AliGW,

Thanks for your reply.

I don't want to calculate working days. If you enter 10/Feb/2020 in column I40 you will see that I22 to I31 highlighted.

Now is it possible that the highlighted tasks should not be between 19/Dec/2019 to 11/Jan/2020. If the tasks comes in between these days it should automatically be moved before 19/Dec/2019 and not only highlighted tasks, accordingly all other tasks due date moved back.

Am sorry I was unable to explain properly and I hope this is more clear now.

Many thanks,