Forum Discussion
Calculating a future date taking holidays into account
Hello folk's, I'm trying to calculate a 2 month future date that excludes holidays and weekends. I have one formula that calculates 10 working days, which is shown below and works perfectly well...
=IF(H10="","",WORKDAY(EDATE(H10,2)-1,1,Q7:Q45))
HansVogelaar Hans, huge thanks, this works brilliantly. Thank you so much!😃👍