Colombia Working Days Calculator
Count Colombian working days with 18 national public holidays excluded, including Ley Emiliani Monday shifts for moveable holidays.
Count working days in Colombia between any two dates — all 18 national holidays excluded (including Ley Emiliani shifted holidays).
Calculate first, then reuse the result
After you calculate, UtilityPilot can turn the result into a clean note you can paste into your SOP, spreadsheet, CRM, Slack, Notion, checklist or email.
Plain-English result — paste into any tool
For internal process notes
For client-ready wording
For Notion, docs or wikis
Share the tool without your values
No sign-up · No stored inputs · Copied text does not include your entered values
Covers Colombia's 18 national holidays. Fixed-date holidays follow Ley Emiliani (if a holiday falls on a day other than Monday, it is moved to the following Monday), implemented as nth-weekday rules. Easter-based holidays (Holy Thursday, Good Friday) are computed for any year.
Formula
Working Days = Weekdays − National holidays (including Ley Emiliani-shifted Mondays)
Count all Monday–Friday days in the range, then subtract Colombian national holidays. Several holidays are shifted to the following Monday under the Ley Emiliani — these are pre-calculated for each year. Fixed-date holidays (Independence Day, Battle of Boyacá, Labour Day, Christmas, etc.) are not shifted.
Worked Example
Scenario: A Bogotá vendor quotes a 10 working day delivery window starting Thursday 17 April 2025.
Holy Thursday (17 Apr) and Good Friday (18 Apr) fall immediately — two holidays on the first two days.
10 working days + 2 Easter holidays = 12 weekdays forward
Result: deadline falls on 2 May 2025
Colombia observes both Holy Thursday and Good Friday as national holidays — two consecutive working days lost during Easter week. Combined with the frequency of Monday holidays under the Ley Emiliani, Colombia has more frequent long weekends than almost any other country in Latin America.
Common Mistakes
- Using the canonical Catholic holiday date instead of the Ley Emiliani shifted date. Under the Ley Emiliani, Epiphany (canonically 6 January) is shifted to the first Monday on or after 6 January. Ascension is shifted to a Monday, as are Corpus Christi, Sacred Heart, Saints Peter and Paul, Assumption, Columbus Day, All Saints' Day, and Independence of Cartagena. Using the original Catholic dates instead of the Ley Emiliani shifted dates will place holidays on incorrect days of the week.
- Forgetting Holy Thursday. Colombia observes both Holy Thursday (Jueves Santo) and Good Friday as national holidays. Most other countries in Latin America observe only Good Friday. Colombia's two consecutive Easter holidays are frequently overlooked by teams from countries where only Good Friday is a statutory public holiday.
- Underestimating the frequency of Monday holidays. With 10 of 18 Colombian holidays shifted to Mondays under the Ley Emiliani, Colombia has a very high density of three-day weekends throughout the year. Business velocity in Colombia tends to be lower in the weeks following holiday Mondays, particularly in June and July when four holidays cluster within six weeks.
Guide
How to Use
- 1
Enter start and end dates
Select the period to measure. Both dates are inclusive in the count.
- 2
Click Calculate
The tool counts Monday–Friday days and deducts all 18 Colombian national holidays, using Ley Emiliani-shifted Monday dates where applicable.
- 3
Review excluded holidays
The result names any holidays excluded within your date range, including whether they are Ley Emiliani-shifted.
- 4
Note June–July density
Four Colombian holidays cluster in June–July. Build extra buffer into timelines spanning this period.
FAQ