Holidays Function

A description of the holidays function, and a list of the available country codes.

Last updated: June 7, 2021

What is the holidays function?

The holidays function is one of the date and time functions Plecto has implemented to make working with date and time objects easy. It is used in the advanced formula editor, where it will return the number of holidays in a given interval. This function allows you to exclude public holidays from your metrics.

Formula_Holidays DK.png

An example of a formula that will return the number of Danish holidays. StartDate and EndDate represent the start and end dates selected on the widget.

The holidays function is widely used with the Networkdays function which counts the number of working days within a set time period. For example, you have established a Month to Date target and want to see the number of deals you have to make per day based on your target. With the holidays function, you can exclude the holidays from the day count to only look at the days you are working and display your daily target accordingly.

Networkdays_Holidays.png

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

Available country and regional codes

Europe

"AT" Austria
"BE" Belgium
"CT" Catalonia
"HR" Croatia
"CY" Cyprus
"CZ" Czechia
"DK" Denmark
"EE" Estonia
"FI" Finland
"FR" France
"DE" Germany
"GR" Greece
"HU" Hungary
"IS" Iceland
"IE" Ireland
"IT" Italy
"LV" Latvia
"LU" Luxembourg
"MT" Malta
"NL" Netherlands
"NO" Norway
"PL" Poland
"PT" Portugal
"RO" Romania
"SK" Slovakia
"SI" Slovenia
"ES" Spain
"SE" Sweden
"CH" Switzerland
"UK" United Kingdom

Americas

"US" United States
"BR" Brazil
"CA" Canada
"CL" Chile
"MX" Mexico
"CO" Colombia
"PA" Panama

Africa

"ZA" South Africa
"DZ" Algeria

Asia

"KR" South Korea
"JP" Japan
"QA" Qatar
"TW" Taiwan

Oceania

"AU" Australia

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

Was this article helpful?