Free Cambodia Public Holiday for Download as Excel File (2020 to 2027)
Looking for a clean, verified, and complete list of Cambodia Public Holidays in Excel format? Download our free, ready-to-use Excel (.xlsx / UTF-8 CSV) holiday calendar featuring official dates, Khmer Unicode names (ឈ្មោះថ្ងៃឈប់សម្រាក), English translations, and categories covering 8 full years from 2020 to 2027.
Cambodia Public Holiday Table (2020–2027)
Search, filter, and export the official Cambodian public holiday calendar (2020 to 2027) directly to Microsoft Excel or Google Sheets.
1Why Every HR & Business in Cambodia Needs an Excel Holiday List
In the Kingdom of Cambodia, managing human resources, employee payroll, attendance tracking, and project deadlines requires accurate public holiday schedules. The Royal Government of Cambodia (រាជរដ្ឋាភិបាលកម្ពុជា) issues an official Royal Sub-Decree (អនុក្រឹត្យ) each year establishing public holidays for civil servants, factory workers, and private sector employees.
Having an official, pre-formatted Excel file allows HR teams and business leaders to:
- Calculate Net Working Days & Payroll: Easily subtract public holidays when processing monthly salaries, OT (Overtime) calculations, or staff leave entitlements.
- Import into ERP & Attendance Software: Integrate official dates into HR software such as QuickBooks, Odoo, SAP, or custom Khmer payroll scripts.
- Prevent Khmer Font Encoding Errors: Traditional CSV files often scramble Khmer script (អក្សរខ្មែរ). Our Excel export uses UTF-8 Byte Order Mark (BOM) encoding to guarantee crisp, error-free Khmer Unicode in Microsoft Excel.
- Plan Multi-Year Business Schedules: Compare holiday distribution across 2024, 2025, and 2026 to optimize project milestones around long holiday periods like Khmer New Year and Pchum Ben.
2Cambodia Public Holiday Summary (2020 to 2027)
Cambodia is renowned for its rich cultural heritage and national observances. Following the official government calendar reforms, the national calendar features 22 official public holiday days per year. Below is an overview of the 8-year dataset:
Historical (2020–2023)4 Years
Complete historical record of official public holiday dates from 2020, 2021, 2022, and 2023 for historical audit, leave reconciliation, and HR records.
Current (2024–2025)2 Years
Includes Khmer New Year, Pchum Ben, Water Festival, and all official national observances for payroll & active project planning.
Upcoming (2026–2027)2 Years
Features 2026 & 2027 holidays calculated via traditional Khmer Chhankitek lunar astronomy rules, including Khmer New Year, Pchum Ben, Water Festival, and Peace Day.
3Major Cambodian Public Holidays Explained
1. Khmer New Year (បុណ្យចូលឆ្នាំខ្មែរ - April 14 to 16)
The grandest traditional festival marking the end of the traditional harvesting season. Families gather for traditional games (ល្បែងប្រជាប្រិយ), temple visits, and water-splashing celebrations.
2. Pchum Ben Ancestors Day (បុណ្យភ្ជុំបិណ្ឌ - September / October)
A 15-day religious ritual where Cambodians pay respect to deceased ancestors. The final 3 days are official public holidays where citizens return to their native homelands to offer food (Bay Ben) at Buddhist pagodas.
3. Royal Water Festival (បុណ្យអុំទូក បណ្តែតប្រទីព និងសំពះព្រះខែ អកអំបុក - November)
Celebrates the unique natural reversal flow of the Tonle Sap River into the Mekong River. Millions gather along the Phnom Penh riverfront for dragon boat racing, illuminated floats (បណ្តែតប្រទីព), and eating Ak Ambok under the full moon.
4How to Use Excel Holiday Data for Working Days Calculation
Once you click Download Excel (.CSV) or Copy to Excel from our downloader tool above, you can perform advanced HR calculations in Microsoft Excel using formulas.
To calculate net working days between two dates while automatically excluding weekends and public holidays, use Microsoft Excel’s built-in NETWORKDAYS formula:
Simply select the Date column from your downloaded Cambodia Public Holiday spreadsheet as the Holiday_Date_Range parameter!
🎬 Video Tutorial: NETWORKDAYS Formula with Holidays
Watch on YouTubeWatch this step-by-step video tutorial to learn how to calculate working days and exclude public holidays using the NETWORKDAYS formula in Excel:
5Official Data Sources & Legal Citations
All public holiday entries in our downloadable Excel spreadsheet are extracted and cross-checked against official Cambodian government publications:
- Royal Government of Cambodia Sub-Decree (រាជរដ្ឋាភិបាលកម្ពុជា): Annual Royal Sub-Decrees (អនុក្រឹត្យ ស្ដីពីប្រតិទិនឈប់សម្រាកការងារ) governing public holidays for civil servants, workers, and employees in the Kingdom of Cambodia.
- Ministry of Labour and Vocational Training (ក្រសួងការងារ និងបណ្តុះបណ្តាលវិជ្ជាជីវៈ - MLVT): Official Labour Law proclamations and holiday circulars.
- Khmer Chhankitek Lunar Astronomy Algorithm (ប្រតិទិនចន្ទគតិខ្មែរ): Official traditional lunar calendar rules computed for moveable religious observances including Visak Bochea, Royal Ploughing Ceremony, Pchum Ben, and Water Festival.
- Royal Gazette of Cambodia (រាជកិច្ចនៃព្រះរាជាណាចក្រកម្ពុជា): The official government gazette published by the Press Office of the Council of Ministers.
Frequently Asked Questions (FAQ)
Q: Are these public holiday dates official for Cambodia?
Yes. All dates in our dataset are compiled according to the official Royal Sub-Decree (អនុក្រឹត្យ) issued by the Royal Government of Cambodia for the years 2024, 2025, and 2026.
Q: Why does Khmer Unicode text look corrupt in Excel, and how does this download fix it?
By default, older versions of Microsoft Excel open standard CSV files using ANSI or ASCII encoding, causing Khmer letters (អក្សរខ្មែរ) to appear as gibberish (e.g. ???). Our exporter injects a UTF-8 Byte Order Mark (BOM Header), forcing Excel to render Khmer script perfectly.
Q: How many public holiday days does Cambodia have each year?
Following the government calendar reforms, Cambodia officially observes 22 public holiday days per calendar year.
Calculate Working Days & Holidays Online
Try our live Working Days Calculator or Khmer Lunar Calendar tools to convert dates, calculate working hours, and check upcoming Cambodian holidays online.