I have a list of 2 dates, start date and end date. I also have a list of days for training between the dates. Lastly I have a list of holiday dates and their days. I'd like to check the holidays and if they're included between the start and end dates I'd like to make up those holidays by adding more dates/days to the end of end date. The thing is, I need the dates of the following days that's scheduled - not just adding extra days.
I have an attached spreadsheet that lists details of what I'm trying to do.