# Bank Holiday calc with Calendar Days

**URL:** <https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110>\
**Category:** Get Answers\
**Created:** [April 2, 2025, 12:41pm UTC](https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110 "2025-04-02T12:41:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vinnie](https://avatars.discourse-cdn.com/v4/letter/v/71e660/32.png) [@Vinnie](https://forums.knack.com/u/Vinnie)\
**Post date:** [April 2, 2025, 12:41pm UTC](https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110/1 "2025-04-02T12:41:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Hugo](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/hugo/32/4068_2.png) [@Hugo](https://forums.knack.com/u/Hugo)\
**Post date:** [April 2, 2025, 1:52pm UTC](https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110/2 "2025-04-02T13:52:10Z")

</div>

Hi Vinnie,  
I have done this by creating a year record, with date fields for BH1 - BH10.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/66b3472f116f6a8323b2a7205fbb2a1a4004ea66.png)

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.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/a/a6f74f1b38caa683380f92e018e8123571843cd8.png)  
I then add each of these duductions together to get a total BH deduction for that holiday (except for Easter almost always only -1).  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/a/a54c5478473a998ed3a229804462e40429bf7385.png)

Et voila!  
Took a while to figure out but it works pretty well.  
Happy to chat through it if needed…  
Hugo

---

<div class="post-metadata">

**Author:** ![Vinnie](https://avatars.discourse-cdn.com/v4/letter/v/71e660/32.png) [@Vinnie](https://forums.knack.com/u/Vinnie)\
**Post date:** [April 2, 2025, 2:28pm UTC](https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110/3 "2025-04-02T14:28:00Z")

</div>

Amazing Hugo, thank you so, so much.. Will do as advised

---

<div class="post-metadata">

**Author:** ![Erik](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/erik/32/982_2.png) [@Erik](https://forums.knack.com/u/Erik)\
**Post date:** [April 4, 2025, 1:04pm UTC](https://forums.knack.com/t/bank-holiday-calc-with-calendar-days/19110/4 "2025-04-04T13:04:13Z")

</div>

That’s a nice solution. It’s unfortunate that the netWorkDays function doesn’t allow a list of holidays (i.e. Excel)