You are looking for the WORKDAY.INTL function.
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Formula for A41:
start_date: take the date from A42.
days: subtract 1 day
[weekend]: the 1 here means weekend is Saturday and Sunday.
[holidays]: This is the range where you have listed the holidays. Adjust the range to match yours.
Drag formula up.