I’m trying to make gantt chart that calculates how long different product will take to make.
Depending on how busy the workshop is we might work in the weekends - however if there is a national holiday or something similar we’ll not work.
I’ve made comma separated iso dates for all holidays.
I can easily calculate an end date with the WORKDAY(startDate, numDays, [holidays]) but I’m trying to find a way to calculate an end date if we worked in the weekends but not holiday.
So basically is it possible to only exclude the holidays?