Working Days Calculator

Working Days vs Calendar Days

Working days (business days) exclude weekends and optionally public holidays. A 30-calendar-day period typically contains about 22 working days. This distinction matters for employment contracts, legal deadlines, shipping estimates, and financial calculations. "Net 30 business days" means 30 working days — approximately 6 calendar weeks. Understanding this difference prevents missed deadlines and incorrect planning.

Public Holidays by Country

Public holidays vary significantly by country. The US has 11 federal holidays, the UK has 8 bank holidays, Nigeria has approximately 11 public holidays, and India has 3 national holidays with numerous state holidays. Some countries observe religious holidays that follow lunar calendars, changing dates each year. Our calculator includes approximate fixed-date holidays for major countries — for precise calculations, verify your country's current year holiday list.

Working Days in Project Management

Project management methodologies use working days for scheduling. The Critical Path Method (CPM) calculates project duration in working days. Agile sprints are typically 2 weeks (10 working days). When estimating project timelines, converting between working days and calendar days helps set realistic client expectations. A "2-week estimate" might mean 10 working days but 14 calendar days — a 40% difference in perceived time.

Payment Terms

"Net 30" typically means 30 calendar days, but some industries use business days. "Net 30 EOM" means 30 days after end of month. Understanding whether terms are in calendar or business days affects cash flow planning. For international business, time zones and different weekend conventions (some Middle Eastern countries observe Friday-Saturday weekends) add additional complexity to deadline calculations.

Excel NETWORKDAYS Function

Excel's NETWORKDAYS function calculates working days between two dates, excluding weekends. NETWORKDAYS.INTL allows custom weekend definitions. You can pass a range of holiday dates as the third argument. Google Sheets supports the same functions. For more complex calculations, WORKDAY adds a specified number of working days to a start date — the inverse operation of NETWORKDAYS.