Formula that calculates vacation days but takes into account the national holidays

Hello guys. I need help creating a formula for days off. At the moment the only idea that i have is like this:

  • using WORKDAYS combined with a timeline column and adding a lot of IF’s and DATE columns to the right with the national holidays
  • setting the DATE column with the default values for the national holidays
    Sincerely this method does not seem elegant and I would have to be extremely careful at the IF’s.
    Any better idea?

You may want to take a look at the NETWORKDAYS function described at The monday Hidden Functions – The Monday Man


3 years on this platform and everything changed with one reply for you. You are awesome. Thanks.
PS: In hindsight, I should’ve checked this forum years ago.

1 Like


Thanks for the credited reference.

Jim - The Monday Man
:magic_wand: Update Magic #1 New update enhancement toolbox
:magic_wand: Column Magic :sparkles:– The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday

1 Like