i have the following formula to give a 2 day cycle for production which will
skip saturdays and sundays. can it be made to miss other days such as public
holidays also if they are put into a table or something.

IF(WEEKDAY(A1+2)=7,A1+4,IF(WEEKDAY(A1+2)=1,A1+4,A1 +2))

whe A1 is first date, formula is in B1:Z1