I have a formula that will happily add a set number of days to a date and if the outcome is a weekend it will then move to the next working day. I need to add another variable to account for any extra holidays the date may land on. Its counting calendar days so the only relevant date is the end date, if it falls on a weekend or another holiday it needs to move to the next working day. What I have so far is this:
=IF(WEEKDAY(E4+10, 2)>5, (IF(WEEKDAY(E4+10, 2)=6, E4+12, E4+11)), E4+10)
E4 is the date to start counting from and this works fine but then I cant find a way of including a list of dates to move the result on again if it lands on one of these dates. I could use extra columns but am trying to do it in one formula.
Any ideas are welcomed.
=IF(WEEKDAY(E4+10, 2)>5, (IF(WEEKDAY(E4+10, 2)=6, E4+12, E4+11)), E4+10)
E4 is the date to start counting from and this works fine but then I cant find a way of including a list of dates to move the result on again if it lands on one of these dates. I could use extra columns but am trying to do it in one formula.
Any ideas are welcomed.