How to Calculate the Days Between Two Dates

October 17, 2026 • NOFYI Editorial Team

Counting the days between two dates sounds like simple subtraction, but most people get it wrong at least once. The confusion usually comes from a single question: do you count the start date, the end date, both, or neither? Two people can use the same two dates, follow different rules, and arrive at answers that differ by one or two days. That difference matters for deadlines, bookings, subscriptions, and plans. This guide explains the two main ways to count, how to calculate each one, and how to avoid the common traps caused by leap years and timezones.

The method is straightforward once you separate two ideas. The first idea is the distance between two dates, which is how many days you must move forward to get from the first date to the second. The second idea is the count of calendar days in a period, which includes both the first and the last day. Both ideas are correct in different situations. The mistake is to use one when you meant the other, or to switch between them without noticing.

Inclusive Versus Exclusive Counting

Inclusive counting includes both the start date and the end date. If an event runs from Monday to Wednesday inclusive, it covers Monday, Tuesday, and Wednesday, which is three days. Exclusive counting, in the sense most date calculators use for a difference, measures the gap between the dates. From Monday to Wednesday is two days apart, because you move forward two days to get from Monday to Wednesday. The inclusive count is one more than the exclusive difference, whenever the end date is after the start date.

A useful formula captures this relationship. Inclusive days equals exclusive days plus one. If the exclusive difference is 0, the inclusive count is 1, because the start and end dates are the same day and that day counts once. If the exclusive difference is 30, the inclusive count is 31. Keeping this formula in mind lets you convert between the two methods without recounting from scratch.

Which method should you use? It depends on what you are counting. Use the exclusive difference when you ask how many days until a date, how many days have passed since a date, or how many days apart two dates are. Use the inclusive count when you ask how many calendar days a period covers, such as a holiday from 1 January to 31 January, a course that runs from Monday to Friday, or a rental that includes both the pickup and return days. If you are writing a deadline, state the rule explicitly, for example, including both the start and end dates, so other people do not have to guess.

How to Calculate the Days Between Two Dates

Start by writing both dates in the same format, with the year, month, and day clearly shown. A format such as 2026-01-01 for 1 January 2026 avoids the confusion caused by different local formats, where 01/02 can mean 1 February or 2 January depending on the country. If the dates include times, note them separately, because a time can change the answer by a day if you are not careful.

Next, decide whether you need the exclusive difference or the inclusive count. If you need the difference, subtract the start date from the end date. In practice, most people do this with a calendar, a spreadsheet, or a date calculator, rather than by hand. A spreadsheet function that returns the difference between two dates will usually give the exclusive difference. If you need the inclusive count, add one to that result. Writing down which result you want before you calculate prevents the most common off-by-one error.

Then check the result with a small test. Count forward on a calendar from the start date, landing on the end date, and count the steps. For example, from 1 January to 2 January is one step, so the exclusive difference is 1. From 1 January to 3 January is two steps. If your calculator gives a different result, check whether you entered the dates correctly, whether the calculator uses inclusive counting, and whether a timezone or time component changed the dates.

Finally, record the dates, the method, and the answer together. A note such as from 1 January to 31 January, exclusive difference 30 days, inclusive count 31 days, is clear and easy to check. A bare number such as 30 days, without the dates or the method, is easy to misread later. When a date calculation affects money, travel, or a deadline, that extra clarity is worth the few seconds it takes.

Worked Example: 1 January to 31 January

Take the period from 1 January to 31 January in the same year. First, find the exclusive difference. January has 31 days. To move from 1 January to 31 January, you move forward 30 days. You can see this by counting: from 1 January to 2 January is 1 day, to 3 January is 2 days, and so on, until 31 January is 30 days after 1 January. So the dates are 30 days apart.

Next, find the inclusive count. The inclusive count includes both 1 January and 31 January. Using the formula, inclusive days equals exclusive days plus one, so 30 plus 1 equals 31. That matches the calendar: January has 31 days, and the period from the first day of January to the last day of January covers the whole month, which is 31 days. Both answers are correct. They answer different questions.

Now apply the same thinking to a practical example. Suppose a subscription runs from 1 January to 31 January inclusive. The subscriber should have access for 31 days, not 30. If a system calculates only the exclusive difference, it might end access one day early. Suppose instead you ask how many days until 31 January, starting on 1 January. The answer is 30 days, because you have 30 days to wait. The same two dates give different useful answers, depending on the question. Stating the question clearly is the key.

Another check helps to confirm the method. If the start and end dates are the same, the exclusive difference is 0 and the inclusive count is 1. That makes sense: there is no gap between a date and itself, but a period that starts and ends on that date covers one calendar day. If your method gives a different result for that simple case, the method is wrong for the question you are asking.

Leap Years

Leap years add one extra day, 29 February, to years that are divisible by 4, with an exception for century years. A year that is divisible by 100 is not a leap year unless it is also divisible by 400. For example, 2024 was a leap year, 2025 was not, and 2000 was a leap year because it is divisible by 400, while 1900 was not. Most date calculators handle this correctly, but manual counting often misses it.

A leap day matters only if your period includes 29 February. A period from 1 January to 31 January never includes it, because January comes before February. A period from 1 February to 1 March does include it in a leap year. In a leap year, 1 February to 1 March is 29 days apart, because February has 29 days. In a non-leap year, the same period is 28 days apart. If you count by hand and assume February always has 28 days, you will be one day short in a leap year.

A practical habit is to check whether the period crosses February in a leap year, and to rely on a calculator or calendar for periods that cross month or year boundaries. If you are calculating many dates, use a spreadsheet or a programming date library rather than mental arithmetic. Those tools apply leap year rules consistently, while mental arithmetic is easy to get wrong when a period spans several months.

Timezones

Timezones can change the date, and therefore the day count, when a date includes a time. A moment that is 1 January at 11 at night in one timezone can already be 2 January in another timezone. If you compare a date recorded in one timezone with a date recorded in another, you may get a difference that is off by one day, even though the calculation itself is correct.

To avoid this, decide which timezone the dates belong to before you calculate. If both dates are calendar dates without times, such as a booking from 1 January to 31 January, use those calendar dates as written and do not convert them. If the dates include times, convert both to the same timezone, or better, to the same calendar date in the timezone that matters for the task, such as the timezone where the event happens. Record the timezone with the dates so someone else can check the result.

Daylight saving can also affect calculations that use exact times rather than calendar dates. On a day when clocks move forward, that calendar day has 23 hours in regions that observe daylight saving. On a day when clocks move back, it has 25 hours. If you calculate the difference by dividing the number of hours by 24, you can get a result that is slightly off around those transitions. For calendar day counting, count calendar dates, not hours. For exact elapsed time, use a tool that understands timezones and daylight saving.

Common Mistakes to Avoid

The most common mistake is the off-by-one error, where the answer is one day too high or too low because the wrong counting method was used. The second most common mistake is to assume all months have 30 days, or that February always has 28 days. The third is to mix date formats, so that 03/04 becomes 3 April in one system and 4 March in another. The fourth is to ignore the time component, so that a period that starts at 6 in the evening and ends at 9 in the morning is counted as two full days when it is much shorter in hours.

A simple checklist prevents most of these mistakes. Write the dates in year-month-day format. State whether you need the exclusive difference or the inclusive count. Check whether the period includes 29 February. Check whether a timezone or time component could change the date. Test the method on a simple case, such as the same date for both start and end, and on a one-day period. If those tests give the expected results, the method is likely correct for the real dates.

Limitations

Counting days between dates tells you the number of calendar days, but it does not tell you how many working days, business days, or school days are in the period. A period of 30 days apart may include four weekends, a public holiday, or a closure day. If you need working days, you must subtract weekends and holidays separately, and you must know which holidays apply in the relevant region. A simple date difference cannot do that on its own.

Date counting also does not capture the time of day. Two periods can both be 30 days apart, but one can start in the morning and end in the evening, while the other starts in the evening and ends in the morning. The calendar day count is the same, but the elapsed hours differ. For deadlines, travel, and bookings, the time of day often matters as much as the date. State the time as well as the date when the task requires it.

Frequently Asked Questions

How many days are there between 1 January and 31 January?

The dates are 30 days apart, using the exclusive difference. The inclusive count, which includes both 1 January and 31 January, is 31 days. Both answers are correct for different questions. Use 30 days for how many days you must move forward, and 31 days for how many calendar days the period covers.

What is the difference between inclusive and exclusive counting?

Inclusive counting includes both the start and end dates. Exclusive counting, as used for a date difference, measures the gap between them and does not count both endpoints. Inclusive days equals exclusive days plus one, when the end date is after the start date. If the dates are the same, the exclusive difference is 0 and the inclusive count is 1.

Does a leap year change the days between two dates?

Yes, if the period includes 29 February. In a leap year, February has 29 days, so a period that crosses 29 February is one day longer than the same period in a non-leap year. If the period does not include 29 February, the leap year does not change the result.

Can timezones change the days between two dates?

Yes, when the dates include times. The same moment can fall on different calendar dates in different timezones, which can shift the day count by one. Use calendar dates as written when no time is involved, and convert times to a single timezone when a time is involved. Record the timezone with the dates.

Calculating the days between two dates is a small skill with a large effect on planning. Decide whether you need the exclusive difference or the inclusive count, use the formula inclusive equals exclusive plus one, and check for leap years and timezones. With the worked example of 1 January to 31 January in mind, 30 days apart and 31 days inclusive, you have a reliable reference you can use to check any other date calculation.

Related tool: Browse all free tools — free to use in your browser, no sign-up.