Adjusting task due date between holidays..


New Member
Jan 13, 2016
Hi Everyone,

I will be great-full if someone can help me with the preferably macro or formula 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.

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 have uploaded a excel file with some examples and I hope you will be able to access it.

In that file I have added conditional formating if you change the delivery date it will highlight Xmas holiday period. No other holidays need to be considered.
If any of the date falling in the Xmas holiday season the Macro / formula should calculate date for the corresponding column without taking the Xmas holidays.

Thanks in advance.


New Member
Jan 13, 2016
Hi Excel Experts,

I really appreciate if anyone of you help me on this.

I have given an example data also or let me know if it's not possible in excel.

Thanks & regards,

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...