Download the template
An Excel file, about 11 KB. No sign-up, and no email address needed.
It opens in Excel, Google Sheets and LibreOffice Calc. There are no macros.
Free template
A free working days calculator for Excel
Count the working days between two dates, leaving out the weekend you choose and the public holidays you list, with the first twelve months shown one row each.
What is in it
- A start date, an end date and a weekend: Saturday and Sunday, Friday and Saturday, Sunday only or Saturday only.
- Working days, calendar days, weekend days and holidays on working days for the range.
- Working days month by month for the first twelve months.
- A holidays sheet to fill with your own region’s, started with Karnataka’s as an example.
Get new templates and tools by email
Optional. We send an email when we publish a new template or guide, and nothing else. You can stop them at any time.
Thank you. You are on the list, and every email says how to come off it.
Nothing was stored: the address did not look right, or the box agreeing to emails was not ticked.
That did not work on our side, and nothing was stored. Please try again later.
Or count them here, without a spreadsheet
The working days tool on this site does the same count for any of those regions and gives the days back as a spreadsheet.
Questions people ask
Is the working days calculator free?
Yes. Download it and use it as you like, with no sign-up and no email address needed.
Does it work in Google Sheets or LibreOffice?
Yes. Every figure is an ordinary formula with no macros, so it opens in Excel, Google Sheets and LibreOffice Calc and works in each.
How does it count?
With NETWORKDAYS.INTL: every day from the start date to the end date, both included, that is not a weekend day and not on the holidays sheet.
Where do I get my region’s holidays?
The public holiday pages on this site list them for every Indian state, Australia, the UK, the US, the Gulf and Singapore, each with a CSV to paste into the holidays sheet.
See it on your own kind of work
We set ReliTime up with a walkthrough rather than a sign-up form. We will take you through a working organisation, from a week of timesheets through approvals and work in progress to a GST invoice, answer your questions as we go, and set up yours.
Or write to hello@relitime.com.