How to Calculate Working Days in Excel with Cambodia Public Holidays (Khmer Video)

Hello everyone! Today I show you step-by-step how to calculate net working days between two dates in Excel and skip weekends plus Cambodia Public Holidays!

In this tutorial & video guide, you will learn:

• How to count business days automatically in Excel (skip Saturday, Sunday, and holidays)
• Difference between NETWORKDAYS and NETWORKDAYS.INTL formulas
• Real-world example using Cambodia Public Holiday list
• Where to download Cambodia Public Holiday Excel files for free

🎥 Step-by-Step Video Guide (Khmer Language)

Video 1: Calculate Working Days using NETWORKDAYS Function

Video 2: Advanced Custom Weekend using NETWORKDAYS.INTL Function

📥 Download Free Cambodia Public Holiday List & Online Tool

Need Cambodia Public Holiday Excel file to practice with formula?
👉 Click Here to Download Cambodia Public Holiday Excel File (2024, 2025, 2026)

🛠️ Want to calculate working days online without Excel?
👉 Try Free Online Working Days Calculator Tool

💡 Useful Tips for Excel User

1. Standard Weekend Off (Saturday & Sunday)

Use NETWORKDAYS function:

=NETWORKDAYS(A2, B2, $D$2:$D$25)

• A2 = Start Date
• B2 = End Date
• $D$2:$D$25 = Range of Cambodia Public Holidays date list from downloaded file

2. Custom Weekend Off (e.g. Only Sunday Off)

Use NETWORKDAYS.INTL function:

=NETWORKDAYS.INTL(A2, B2, 11, $D$2:$D$25)

Tip: Parameter 11 in NETWORKDAYS.INTL means Sunday is the only weekend day off!

📊 Common Weekend Number Codes (NETWORKDAYS.INTL)

📚 Related Tutorial & Resources:

• Free Cambodia Public Holiday List Download (2024-2026)
• How to Calculate Days Between Two Dates in Excel
• How to Show Khmer Date Format in Excel
• Free Online Working Days Calculator Tool