Variable scheduling dates with holidays

[paulma1960]

I'm preparing a weekly work schedule, with Xmas holidays in-between. The start date is not yet ascertained, so I need to be able to vary it, and then the weekly dates automatically flowing on. So, I'm looking for a formula that would automatically adjust the weekly dates, based on the project start date. Any suggestions appreciated.

Proposed start date: 4-Oct-21
Fixed holidays: 27-Dec-21 to 9-Jan-22
Proposed end date: 22-Jul-22

 

[paulma1960]

For the benefit of anyone who might have the same problem, I solved it using this formula in cell A4 and dragging down:

=A3+7+IF(AND(A3+7>=BreakStart, A3-1<BreakEnd), 14, 0)

Now, if the start date changes, the other dates change according to the Xmas Break dates (14 days).