How do I calculate the number of days between two dates?

Select a start date and an end date. The calculator subtracts the start date from the end date and returns the calendar days between the two dates.

Does the days between two dates result include the end date?

Calendar days exclude the end date by default. Turn on Include the end date when you want an inclusive count that includes both the start and end dates.

How do I calculate business days between two dates?

Use Dates mode and read the Business / working days result. It counts Monday through Friday and skips Saturdays and Sundays.

How many working days are between two dates?

Working days usually mean Monday through Friday. This calculator reports working days between two dates and also shows weekend days separately.

How do I calculate days between two dates in Excel?

Use =B1-A1 for calendar days, =B1-A1+1 for inclusive days, or =NETWORKDAYS(A1,B1) for working days between two dates.

Can this calculate hours between two date-times?

Yes. Switch to Date & time mode if you need days, hours, minutes, seconds, total hours, total minutes, or total seconds between exact timestamps.

Days Between Two Dates Calculator

Calculate days between two dates, business days, working days, weekend days, weeks, or a precise time duration between two date-time values.

Start dateEnd date

Include the end date

Use Dates mode to calculate the number of days between two dates. Calendar days exclude the end date by default, while the inclusive count includes both start and end dates.

Days Between Two Dates Formula

days between two dates = end date - start date

The number of days between two dates is the difference between the end date and the start date. This gives calendar days by default. If you include the end date, add one day to the result. Business days count weekdays in the same date span and skip Saturdays and Sundays.

Symbol	Variable	Description
start date	Starting date	The first date in the day count.
end date	Ending date	The second date used to calculate the date difference.
business days	Weekdays	Monday through Friday within the selected date range.

How to Calculate Days Between Two Dates

1
Enter the start date
Choose the first date in the range. This can be a project start, invoice date, travel date, or any calendar date.
2
Enter the end date
Choose the second date. The calculator shows how many calendar days are between the two dates.
3
Choose inclusive counting if needed
Turn on Include the end date when you want to count both dates, such as a hotel stay, event span, or deadline window.

Common Days Between Two Dates Examples

These examples show the difference between a standard calendar day count and an inclusive count of the days between two dates.

Start date	End date	Calendar days	Inclusive days
January 1	January 2	1	2
January 1	January 31	30	31
February 1	March 1	28 or 29	29 or 30
Friday	Monday	3	4
June 1	June 30	29	30

Business Days Between Two Dates

Business days between two dates count weekdays only. This is useful for invoices, service-level agreements, hiring timelines, school planning, and project schedules. The calculator treats Monday through Friday as working days and skips weekends.

Business days and working days are counted as Monday through Friday.
Weekend days are shown separately so you can see what was excluded.
Public holidays are not removed automatically because holiday calendars vary by country, state, and organization.
Use inclusive counting when your policy counts both the start date and end date.

Excel Days Between Two Dates

In Excel, the number of days between two dates is commonly calculated by subtracting the start date from the end date. For example, if A1 is the start date and B1 is the end date, B1-A1 gives calendar days between the two dates.

Excel calendar days: =B1-A1
Excel inclusive days: =B1-A1+1
Excel working days: =NETWORKDAYS(A1,B1)
Excel working days with holidays: =NETWORKDAYS(A1,B1,holiday_range)