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

Platform discussions Special workflows & use cases
1

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?
2

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

2 Likes
3

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
4

@GCavin

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