No votes yet

How to Count Days Between Two Dates

Counting days between dates means walking the calendar from one date to the other, or subtracting their day numbers. In a spreadsheet the same job is one date minus the other.

Dates By Online Alarm Clock

To count days between two dates, first decide whether the starting and ending dates are included. The ordinary date difference excludes the start date: from May 1 to May 2 is one day. An inclusive count includes both calendar dates, so the same range contains two days. Use the days calculator for an immediate result, but state the counting convention whenever the answer matters.

Most disagreements are not arithmetic errors. They come from different definitions: calendar days versus working days, elapsed 24-hour periods versus dates touched, or whole months versus average-length months. Write the question in full before calculating: “How many calendar days after March 3 is the deadline?” is clearer than “How many days?”

The basic subtraction rule

Treat each date as a position on a continuous calendar and subtract the earlier position from the later one. From June 10 to June 15, the boundaries crossed are 10 to 11, 11 to 12, 12 to 13, 13 to 14, and 14 to 15: five days. This standard difference includes the ending boundary but not the starting date as a counted day.

For an inclusive range, add one to the standard difference. June 10 through June 15 includes the 10th, 11th, 12th, 13th, 14th, and 15th: six calendar dates. This is common for hotel stays described as days on site, leave periods, and event schedules, but not universal.

QuestionMay 1 to May 2Typical interpretation
Days between1Exclude the start date
Dates included2Include both endpoints
Nights1Count overnight boundaries
24-hour periodsDepends on times and zoneUse timestamps, not dates alone

Should the last day be included?

There is no universal answer; it depends on the rule governing the task. A deadline “within 10 days after receipt” may exclude the receipt date under the applicable policy or law. A vacation “from July 1 through July 7” usually includes both dates. A hotel booking from July 1 to July 7 normally means six nights, with checkout on the 7th.

Look for words such as “after,” “through,” “starting,” “nights,” and “business days.” For contracts, court deadlines, benefits, and financial interest, use the exact governing definition and holiday calendar. A general calculator can perform the math but cannot interpret a legal rule.

Counting working days

A basic working-day count includes Monday through Friday and excludes Saturday and Sunday. A business-day count often also excludes public holidays. Those two results can differ. Holiday calendars depend on country, region, organization, and sometimes industry.

  1. Choose whether the start and end dates count.
  2. List every date in the range or calculate full weeks.
  3. Remove Saturdays and Sundays.
  4. Remove holidays observed by the relevant organization.
  5. Apply any special rule when a holiday falls on a weekend.

Ten calendar days are not necessarily ten working days. A two-week Monday-to-Monday span is 14 standard elapsed days but normally contains 10 weekdays if no holidays intervene. Use date tools to inspect weekdays, then apply the correct local holiday list.

A fast manual method for weekdays

Separate the span into complete seven-day weeks and leftover days. Every complete week contains five weekdays. Multiply full weeks by five, then examine each remaining date for Saturday or Sunday. Finally remove applicable holidays.

Endpoint rules still matter. If the start is excluded, begin examining the following date. If both endpoints are included, include each when it is a permitted workday. Write the convention beside your result so another person can reproduce it.

Leap years

In the Gregorian calendar, a year is a leap year if it is divisible by 4, except century years must also be divisible by 400. Thus 2024 and 2028 are leap years; 1900 and 2100 are not; 2000 is. A leap year has February 29 and 366 days.

If a range crosses February 29, that date contributes one additional day compared with the same span in a common year. Reliable date software applies the rule automatically. For manual work over multiple years, count the leap days explicitly rather than assuming one every four years.

YearDivisible by 4?Century exceptionLeap year?
2024YesNot a centuryYes
1900YesNot divisible by 400No
2000YesDivisible by 400Yes
2100YesNot divisible by 400No

Converting days to weeks

Divide the day difference by seven. A span of 45 days is six weeks and three days because 6 multiplied by 7 is 42. For a decimal answer it is approximately 6.43 weeks, but “6 weeks 3 days” is usually easier to interpret.

Calendar weeks are a different concept. A calendar-week count may ask how many labeled Monday-to-Sunday or Sunday-to-Saturday blocks a range touches. Two dates only two days apart can fall in different calendar weeks. Define whether you mean elapsed weeks or week numbers.

Why months cannot be a fixed conversion

Months have 28, 29, 30, or 31 days. Therefore “90 days” is not always exactly three calendar months, and “one month after January 31” needs a convention because February has no January 31 equivalent. Software may clamp to February’s last day or roll extra days into March.

For age, subscriptions, and anniversaries, calendar arithmetic is often appropriate: advance the month field and handle the end-of-month policy explicitly. For elapsed duration, count days. Do not divide by 30 unless an approximation is acceptable and clearly labeled.

Years, birthdays, and age

A person’s age in completed years increases on the birthday, not after a fixed number of 365-day blocks. Leap years make fixed-day division inaccurate. Compare the birth month and day with the current month and day after subtracting the years.

February 29 birthdays require a convention in non-leap years for some administrative purposes. Different laws and organizations may recognize February 28 or March 1. A calculator should not silently decide a legal result; select the rule that applies.

Dates versus timestamps

A date has no hour or time zone. Two midnights can be 23 or 25 elapsed hours apart where daylight saving time changes, even though the dates are consecutive. If the question is calendar days, compare dates. If it is exact elapsed time, compare timestamps representing real instants.

For example, from noon Saturday to noon Sunday across a spring-forward change may be 23 elapsed hours locally. The calendar difference is still one day. Consult the daylight-saving guide and the time-zone guide when precise durations cross zones or clock changes.

Counting backward and reversed dates

If the ending date precedes the starting date, a mathematical difference is negative. From May 10 to May 7 is minus three days. Some calculators instead show an absolute distance of three days. Both can be useful, but the sign conveys direction.

For “30 days before” a date, subtract 30 calendar boundaries and do not add an inclusive day unless the instruction says to count both endpoints. Verify the weekday after calculating. A backward countdown may be better described as elapsed time since an event.

Common examples

RangeStandard differenceInclusive dates
January 1 to January 10 days1 date
January 1 to January 87 days8 dates
February 28 to March 1, common year1 day2 dates
February 28 to March 1, leap year2 days3 dates
December 31 to January 11 day2 dates

Use the online day counter for long spans. Check important milestones on a calendar and save the input dates with the result. If you are comparing local dates in distant places, consult the world clock; one place may already be on the next date.

A reliable checklist

When planning a public event, link the result to a clear endpoint using countdown pages. For exploring annual calendars, the date toolkit helps connect dates, weekdays, and related calculations without mental arithmetic.

Questions and answers

How many days are there from Monday to Tuesday?

The standard date difference is one day. If you count both Monday and Tuesday as included dates, the inclusive count is two.

Do I include the ending date?

Standard subtraction reaches the ending date and excludes the start. An inclusive range counts both, so add one. Follow any specific contractual or legal definition.

Are business days the same as weekdays?

Not always. Weekdays exclude weekends; business days commonly exclude relevant public or organizational holidays as well.

Is every fourth year a leap year?

Almost. Years divisible by 4 are leap years, but century years are not unless divisible by 400. That is why 2000 was a leap year and 2100 will not be.

How many months are 90 days?

There is no exact universal answer because month lengths differ. Treat 90 days as a duration; convert to calendar months only with an explicit convention.

how many days in between two dates

On paper, write the later date above the earlier date and subtract, borrowing from months the way you borrow from columns of figures. A month you borrow from has its real length: thirty from June, thirty-one from July, twenty-eight or twenty-nine from February. The remainder is how many days in between two dates as elapsed time.

On a wall calendar, put a finger on the start square and move one square at a time until you reach the end. The number of moves is the elapsed count. The number of squares you touched is the inclusive count if you also touched the start. People who count “sleeps” until an event are usually counting the moves, not the squares.

Whole weeks speed the walk. Every seven squares returns you to the same weekday. Count the complete weeks, multiply by seven, then add the leftover days. If the weekdays of start and end do not match that leftover, a week was dropped or invented. The weekday is a checksum, not a decoration.

Do not trust knuckle rhymes for a span that crosses February unless you already know whether that February is twenty-eight or twenty-nine days. The rhyme remembers which months have thirty-one days. It does not remember leap years.

Counting days between dates in Excel

Counting days between dates in Excel is subtraction when both cells are real date values. If the start sits in A1 and the end sits in B1, the formula B1-A1 returns elapsed days. The DAYS function does the same job with the end first: DAYS(B1,A1). Both leave the start date out in the usual sense: 15 June minus 10 June is 5.

DATEDIF(A1,B1,"D") also returns whole days from start to end. NETWORKDAYS is not that function. NETWORKDAYS counts weekdays and, by design, includes both the start and the end when those dates are weekdays. Mixing NETWORKDAYS with B1-A1 without noticing that inclusive rule is how a sheet stays “off by one” for a whole project.

Store each date as a date value, not as text that merely looks like a date. Subtract, or use DAYS, for elapsed calendar days. Add 1 if the sheet must treat both endpoints as days on which something happened.

Use NETWORKDAYS only when you mean weekdays, and remember it counts both ends when they are workdays. Excel’s default 1900 date system treats 1900 as a leap year, which the Gregorian calendar does not. Serial date 60 displays as 29 February 1900, a date that never occurred. For differences that sit entirely after 1 March 1900, the extra fake day sits outside the span and subtraction still matches civil dates. Do not use that system to reason about January and February of 1900 itself.

Excel will subtract two dates all day. It will not tell you whether Friday was meant to count.

A paper count that you can still check later

If you must count without a sheet, list the months, then expand them. From 12 March to 4 July: leftover March days after the 12th, plus April, May, June, plus four days of July. Check February only if it appears in that list. Check the leap rule only for that February’s year.

Write the convention on the same line as the answer: elapsed or inclusive. A future reader, including you next week, will not remember which of the two you meant. The arithmetic is the easy half. The rule is the half that evaporates.

Questions and answers

What Excel formula counts days between two dates?
If A1 is the start and B1 is the end, use B1-A1 or DAYS(B1,A1). Both give elapsed days. Add 1 for an inclusive count of dates.
Why is NETWORKDAYS different?
It skips weekends, can skip a holiday list, and includes the start and end when they are workdays. It is not a drop-in replacement for subtraction.
Can I count by typing the dates as text?
Only if Excel has already parsed them as dates. Text that merely resembles a date will not subtract. Check that the cells are date values before you trust the minus sign.

Related guides

Alarms

How to Set an Alarm on Any Device

Set a reliable alarm on an iPhone, Android phone, Windows or Mac computer, smart speaker, or web browser, with practical checks that prevent missed alerts.

All guides

All pages