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.
Thanks for the credited reference.
Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Apps, Integrations & Automations for monday