Business days calculator › Colombia
Business days calculator: Colombia
Count working days between two dates in Colombia, or add business days to a date. Weekends (Saturday and Sunday) and Colombia public holidays are skipped.
Planning time off? See how to maximise your annual leave in Colombia in 2027: the exact days to book for the longest breaks.
Working days in Colombia, 2026 and 2027
| Month | 2026 | 2027 |
|---|---|---|
| January | 20 | 19 |
| February | 20 | 20 |
| March | 21 | 20 |
| April | 20 | 22 |
| May | 19 | 19 |
| June | 19 | 21 |
| July | 21 | 19 |
| August | 19 | 21 |
| September | 22 | 22 |
| October | 21 | 20 |
| November | 19 | 20 |
| December | 21 | 22 |
| Total | 242 | 245 |
National public holidays only; weekends are Saturday and Sunday.
Public holidays in Colombia, 2026
| Date | Day | Holiday |
|---|---|---|
| 1 Jan 2026 | Thursday | New Year's Day |
| 12 Jan 2026 | Monday | Epiphany |
| 23 Mar 2026 | Monday | Saint Joseph |
| 2 Apr 2026 | Thursday | Maundy Thursday |
| 3 Apr 2026 | Friday | Good Friday |
| 5 Apr 2026 | Sunday | Easter Sunday |
| 1 May 2026 | Friday | Labour Day |
| 18 May 2026 | Monday | Ascension Day |
| 8 Jun 2026 | Monday | Corpus Christi |
| 15 Jun 2026 | Monday | Sacred Heart |
| 29 Jun 2026 | Monday | Saints Peter and Paul |
| 13 Jul 2026 | Monday | Virgin of Chiquinquirá |
| 20 Jul 2026 | Monday | Independence Day |
| 7 Aug 2026 | Friday | Battle of Boyacá |
| 17 Aug 2026 | Monday | Assumption |
| 12 Oct 2026 | Monday | Columbus Day |
| 2 Nov 2026 | Monday | All Saints' Day |
| 16 Nov 2026 | Monday | Independence of Cartagena |
| 8 Dec 2026 | Tuesday | Immaculate Conception |
| 25 Dec 2026 | Friday | Christmas Day |
Full lists with long weekends: Colombia public holidays 2026 · Colombia public holidays 2027
Holiday list for Excel and Google Sheets
Paste these dates into a column, name the range Holidays, then use=NETWORKDAYS(A2, B2, Holidays) to count working days or =WORKDAY(A2, 10, Holidays) to add them.
Subscribe to Colombia holidays in your calendar
Add every Colombia public holiday to Google Calendar, Outlook or Apple Calendar. The feed updates automatically each year.
Add to Google CalendarApple / Outlook (webcal) ·Download .ics
Frequently asked questions
How many working days are there in Colombia in 2026?
242 working days, counting Saturday and Sunday as the weekend and excluding national public holidays that fall on working days. State or regional holidays can reduce this further.
Which days are the weekend in Colombia?
Saturday and Sunday. You can change the weekend days in the calculator options if your workplace differs.
Does this include local holidays?
Colombia has no separate regional holiday calendars in our data, so national holidays apply everywhere.