Skip to main content

How does it work?

The Holidays function is one of the date functions Plecto has implemented to make working with date-time objects easier. It returns the number of holidays from a list of countries that you can select directly in the formula editor.

The number depends on the start and end dates you select in the formula editor and the time period set on the widget.

Example – Start date: Widget start date, End date: Widget end date

If widget's time period is Current year, you will see the total number of holidays in a given country for this year. If you choose the United States, the number will be 11, but if you select Denmark, the formula will return 8.

How to use the function

When building formulas, the Holidays function is often combined with the Workdays function, which counts the number of working days within a set time period.

Say you want to create a month-to-date target formula. The Holidays function allows you to exclude the holidays from the day count to only look at the days you are working and display your to-date targets accordingly.

Available countries and regions

Austria, Belgium, Catalonia, Croatia, Cyprus, Czechia, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Italy, Latvia, Luxembourg, Malta, Netherlands, Norway, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, Switzerland, United Kingdom

United States, Brazil, Canada, Chile, Mexico, Colombia, Panama

South Africa, Algeria

South Korea, Japan, Qatar, Taiwan