How to use the date calculator
"How many days until the deadline?" "How many working days did this project take?" Counting on a calendar is slow, and Excel means remembering formulas. This tool turns the two most common date calculations into fill-in-the-blank boxes: work out an interval, or project a date forward by a number of days.
What each mode calculates
Interval between two dates. Enter a start and end date and the tool gives the difference in days, weeks, months and years, plus how many weekend and working days fall in between. Good for project durations, leave days, or how long until an exam.
Project a date by a number of days. Give a base date and a day count (which can be negative) and it returns the target date. Good for "when does the 90-day warranty end" or "remind me 30 days ahead".
Inclusive vs exclusive counting
This is where date calculations disagree most often. From 1 January to 2 January, how many days apart are they?
- Excluding the end date (the default): 1 day. This is the mathematical distance between two points, and what most programs do.
- Including the end date: 2 days. This is the everyday way of speaking — one night in a hotel is really two days.
Leave requests, payroll and project schedules run into disputes here constantly. This tool defaults to the first (mathematical interval); tick "include end date" when you need the second.
For example: 1 January to 31 January is 30 days exclusive and 31 days inclusive. But the answer to "how many days are in January" is 31 — so to total up the days in a month you want inclusive counting.
How working days are counted
With "exclude weekends" ticked, the tool counts the Monday-to-Friday days in the range. Two caveats:
- It looks only at the day of the week, not at public holidays. Statutory holidays and the weekends people work to make up for them are both invisible to the tool. For a precise figure you need that year's official holiday schedule.
- Weekend means Saturday plus Sunday. If your company has a six-day week or alternating weeks, adjust the result yourself.
For most estimating work, though — project planning, duration estimates — excluding weekends alone is already close enough to reality.
Leap years and month lengths
The tool uses the real calendar and handles leap years and differing month lengths automatically. A few points people often get wrong:
- The leap year rule: divisible by 4 is a leap year, but divisible by 100 is not, and divisible by 400 is again. So 1900 was not a leap year but 2000 was.
- Months aren't a simple division by 30. The tool reports "whole months plus leftover days" — 15 January to 10 March is 1 month and 23 days.
- No time zone enters the calculation. All dates are treated as local calendar dates; there is no cross-time-zone conversion.
Frequently asked questions
Why doesn't the day count match what I got elsewhere?
Nine times out of ten it's the inclusive/exclusive difference. Check whether "include end date" is ticked. Also check you didn't swap the start and end dates — the tool allows a start later than the end, and the result comes out negative.
Can it account for public holidays?
Not automatically. Statutory holidays are announced each year by the State Council and include make-up working days, so they can't be derived from a fixed rule. The tool only excludes weekends; adjust for holidays by hand.
What is a negative day count for?
Projecting backwards. To find what date was 30 days ago, enter -30. The result shows a historical date, which is handy for reconciling accounts or tracing records.
What if the result goes out of range?
The tool uses JavaScript's date system, which covers 271,821 BCE to 275,760 CE — far more than everyday use needs. Outside that it reports an error.
Is my data uploaded?
No. The calculation happens entirely in your browser with no network request at all. Try it with your connection off — it still works.