I’ve created a holiday booking solution which, is working fine when booking over weekends etc. But I cant find anything or any guidence on how to deducted bank holidays! I’ve looked at flows and this doesn’t seem to work either.. If anyone has done this or can share how, it would be appreciated.
Hi Vinnie,
I have done this by creating a year record, with date fields for BH1 - BH10.
I then connect each holiday record to the appropriate year, and have a field for each BH that sets a value of -1 if the start is on or before the BH, or the end is on or after.
I then add each of these duductions together to get a total BH deduction for that holiday (except for Easter almost always only -1).
Et voila!
Took a while to figure out but it works pretty well.
Happy to chat through it if needed…
Hugo
1 Like
Amazing Hugo, thank you so, so much.. Will do as advised
That’s a nice solution. It’s unfortunate that the netWorkDays function doesn’t allow a list of holidays (i.e. Excel)