Date calculator for HR
Five date calculations HR and payroll work actually needs, in one place. Choose a mode and the fields change to match. Every result can be downloaded as a spreadsheet for attaching to a file or a case note.
Uses a published standard formula, named below. Calculations run in your browser. Nothing is sent to a server. Not financial advice.
What do you need to work out?
Optional. Accrues per completed month of service.
On by default. Leave and notice periods normally count both dates, so 1 to 30 June is 30 days. Turn it off to measure days elapsed instead, which gives 29.
One date per line or comma separated, in YYYY-MM-DD format. Leave blank to ignore holidays.
Result
—
Show the working
—The six modes
Days between two dates is the plain one. Give it two dates and it returns the gap, with no weekend or holiday options to think about.
Working days between two dates adds the weekend pattern and your holiday list, then counts only the days your organization actually operates.
Add or subtract time moves a date forward or back by days, weeks, months or years. It also shows the next working day, which matters when a deadline lands on a Saturday.
Count working days is the one most calendars get wrong. Counting thirty working days forward is not the same as counting thirty days. Weekends and holidays are skipped entirely, so the real date lands several weeks later than people expect. This is the calculation behind notice periods, probation windows and statutory response deadlines.
Length of service gives completed years, months and days from a joining date, plus completed months and optional leave accrual.
Countdown counts calendar and working days to a future date, or since a past one.
Counting both dates, or the days between them
This is the single most common source of disagreement in date arithmetic, so the calculator handles it explicitly rather than picking one silently.
From 1 June to 30 June there are 29 days elapsed and 30 days inclusive. Both figures are correct. They answer different questions.
Leave, notice periods and suspension all count inclusively, because the employee is absent or serving on both the first day and the last. Project durations and interest calculations usually count elapsed days, because you are measuring the distance between two points rather than occupying them.
The checkbox is on by default, since HR work needs the inclusive figure far more often. Both numbers appear in the results either way, so you never have to guess which convention produced the answer.
Why weekend patterns are configurable
Most date tools hardcode Saturday and Sunday, which is wrong for a large part of the world. The working week runs Sunday to Thursday across much of the Middle East, with Friday and Saturday as the weekend. Nepal has a one-day weekend. Some organizations operate six-day weeks.
Pick the pattern that matches your organization before counting anything. The error compounds: over a thirty working day notice period, the wrong pattern shifts the end date by several days.
Holidays
Paste your organization's holiday list into the box, one date per line or comma separated, in YYYY-MM-DD format. Those dates are excluded from every working day count.
This is deliberately manual rather than automatic. Public holidays vary by country, by province and by whether your organization observes them. A calculator that guessed would be wrong often enough to be dangerous in an employment context. Keeping your own list in a text file and pasting it in takes seconds and leaves an auditable record.
Calendar months are not thirty days
A common source of disputes. Adding one month to 31 January cannot produce 31 February, so the result rolls into March. Adding three months to 30 November gives 28 or 29 February depending on the year.
This calculator uses standard calendar arithmetic, which is what employment contracts normally mean by one month's notice. If your contract specifies a number of days instead, use the days unit. The two give different answers, and which one applies is a question about the contract wording rather than the mathematics.
The spreadsheet download
Every result can be downloaded as a CSV, which opens directly in Excel, Google Sheets or LibreOffice with a double click. For the range modes the file contains a row per date with its day of the week and whether it counted as working, weekend or holiday. That is exactly what you need when someone queries a calculation months later.
Not legal or employment advice. Notice periods, probation rules, leave accrual and statutory deadlines are governed by your jurisdiction and by the specific contract. This tool does calendar arithmetic on the parameters you supply. Confirm the rules with a qualified employment adviser before acting on a date.
Frequently asked questions
Is 1 June to 30 June 29 days or 30?
Both, depending on what you are measuring. Thirty days counts both the first and the last date, which is how leave and notice periods work. Twenty-nine counts the days elapsed between them. The calculator shows both figures and lets you choose which one leads.
How do I count working days between two dates?
Use the difference mode, set your weekend pattern and paste any public holidays into the box. The result separates calendar days, working days, weekend days and holidays.
What is the difference between calendar days and working days?
Calendar days count every day including weekends and holidays. Working days count only days the organization operates. Thirty working days is roughly six weeks of calendar time, which is why the two produce very different end dates.
Can I use a Friday-Saturday weekend?
Yes. The weekend pattern selector supports Saturday-Sunday, Friday-Saturday, Sunday only or no weekend at all for organizations that operate every day.
How is length of service calculated?
In completed years, months and days from the joining date, using calendar arithmetic that borrows correctly across months of different lengths. Completed months are also shown, since many accrual policies work on that basis.
What happens when adding a month to the 31st?
The result rolls into the following month, because the target month has no 31st. Adding one month to 31 January gives 3 March in most years. If your contract counts in days, use the days unit instead.
Can I download the result?
Yes. The download button produces a CSV that opens in Excel, Google Sheets or LibreOffice. For date-range calculations it includes a row per date showing whether it counted as working, weekend or holiday.