Is there a way to include US holidays on the Monday.com calendar? We are using Formula to calculate Working Days and it is not capturing holidays.
1 Like
Since you are using a formula to calculate working days, you might look to a formula similar to the one below. It calculates the net work days excluding the listed holidays.
NETWORKDAYS({Requested Dates#Start}, {Requested Dates#End},
ARGS2ARRAY("2024/01/01","2024/03/18","2024/03/25","2024/05/01","2024/05/06","2024/06/24", "2024/08/15","2024/10/28", "2024/12/25","2024/12/26")
)
Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
I had ChatGPT create a CSV of holidays and imported them as items. This was the only workaround I could find to get holidays to appear without manually creating every one.
Monday doesn’t automatically include US holidays, but you can add them manually by creating a “Holiday” list. Then, adjust your “Working Days” formula to exclude these dates.
There may be two ways to include holidays on Monday.com
Manually include Holidays in a separate column.
When calculating working days using formulas like NETWORKDAYS, include a reference to this holiday list to exclude those days.
Third-party integrations or alternative calculation methods.
This is an excellent solution - Inevitably, end users want to be able to tweak what is considered a holiday, accommodate a particular organization to observe certain holidays, accommodate spanning different countries with different holidays, etc.