Apply holidays and weekends when adding days to date
Solution 1:
Use the WORKDAY(start_date,duration,[list_of_holidays]) for example =WORKDAY(B2,C2,I2:I5) this will give you the serial number of the date convert it to date format or use =TEXT(WORKDAY(B2,C2,I2:I5),"dd-mm-yy")