Holidays Function

Learn about the Holidays date function and see the list of the available countries.

Last updated: June 16, 2022

The Holidays function is one of the date functions Plecto has implemented to make working with date and 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.

holidays-date-function-formula-editor.png

For example, with Start date: Widget start date, End date: Widget end date and the time period on the widget set to "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.

The calendar library Plecto is using for this date function comes from GitHub. Please read GitHub's article if you would like to know more.

How to use the Holidays function in formulas

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. Adding 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.

holidays-function-formula-example-MTD.png

An example of a formula that will return the number of working days. It excludes weekends and Danish public holidays.

Europe
  • 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
Americas
  • United States
  • Brazil
  • Canada
  • Chile
  • Mexico
  • Colombia
  • Panama
Africa
  • South Africa
  • Algeria
Asia
  • South Korea
  • Japan
  • Qatar
  • Taiwan
Oceania
  • Australia

Read more: Click here if you want to learn more about the date and time functions.

Was this article helpful?