Working Days Calculator

Count business days between two dates, excluding weekends

Enter holidays that fall on weekdays in this period (Republic Day, Diwali, etc.)
Excel courseLearn Excel from beginner to confident userthe Udemy course by Ajay Anand, 7× Microsoft Excel MVPView the course →
Working days
—
—
Total calendar days
—
Weekend days
—
Public holidays
—
Working weeks
—

About Working Days

What counts as a working day in India?

Most Indian companies follow a 5-day work week (Monday to Friday). Government offices and some sectors like banking may follow a 6-day week (Monday to Saturday). Public holidays vary by state and organisation.

Common uses

Notice period calculation (typically 30–90 working days), project deadlines, delivery timelines, loan processing periods, and legal notice periods all use working day counts rather than calendar days.

Free tutorialsFree Excel tips & tutorials at XLnCADstep-by-step guides by a 7× Microsoft Excel MVPVisit xlncad.com →

Master Excel & Google Sheets

These calculators give you quick answers — but building them yourself in a spreadsheet is a real superpower. Learn Excel from the basics to confident, everyday use in my top-rated Udemy course.

Start the Excel course →