Days In Between Calculator

Example Data Table

These examples show how endpoint and exclusion rules change the final count.

Start Date	End Date	Rule	Expected Meaning	Typical Use
2026-01-01	2026-01-31	Include end only	30 raw days	Standard date gap
2026-01-01	2026-01-31	Include both endpoints	31 calendar dates	Membership period
2026-03-01	2026-03-15	Exclude Saturday and Sunday	Working days only	Business deadline
2026-12-20	2026-12-31	Exclude custom holidays	Filtered planning days	Holiday schedule

Formula Used

The calculator first normalizes the two dates. The earlier date becomes A. The later date becomes B.

Raw days: B - A

Effective start: A if start is included, otherwise A + 1 day

Effective end: B if end is included, otherwise B - 1 day

Selected calendar days: max(0, effective end - effective start + 1)

Final counted days: selected calendar days - excluded weekend dates - custom excluded dates

Weeks: final counted days / 7

Approximate months: final counted days / 30.436875

Approximate years: final counted days / 365.2425

Custom dates and weekend dates are not double-subtracted when they overlap. Each calendar date can be removed only once.

How To Use This Calculator

Select the start date and end date.

Choose whether the start date should count.

Choose whether the end date should count.

Turn on weekend exclusions if you need working days.

Select the weekend days used by your schedule.

Add custom excluded dates when needed.

Press the calculate button.

Download the result as CSV or PDF.

Plan Dates With Confidence

A days in between calculator helps you compare two calendar dates. It removes guesswork from schedules, invoices, travel plans, subscriptions, and project work. You can count simple calendar days. You can also adjust the range with inclusive start and end rules.

This tool supports common planning cases. A manager may need the number of billable service days. A traveler may need nights between arrival and departure. A student may count study days before an exam. A contractor may exclude weekends from a deadline.

Why Counting Rules Matter

Date counting sounds simple, but rules change the answer. The normal difference between two dates excludes the starting date. Inclusive counting can add the start date, the end date, or both. That choice matters for rent, leave balances, warranty periods, and delivery windows.

Weekend rules also matter. Some teams work Monday through Friday. Others may treat Friday and Saturday as weekends. The calculator lets you choose weekend days. It can also remove custom dates, such as holidays, shutdown days, or personal leave dates.

Better Reports For Daily Work

The result shows several useful views. You get the raw day gap. You also get the selected calendar count after endpoint choices. Then you get the final counted days after exclusions. Extra values show weeks, hours, approximate months, and approximate years.

Exports make the result easier to save. Use the CSV file for spreadsheets. Use the PDF file for records, quotes, or planning notes. The example table shows how different rules can change totals.

Practical Tips

Always confirm the counting rule before sharing a result. Ask whether the start date should count. Ask whether the end date should count. Check which days are weekends for the business or country involved. Add holidays when deadlines require working days only.

Use calendar days for simple age, trip, or storage calculations. Use filtered days for work schedules, billing periods, and service windows. Keep a copy of the exported result when dates affect money, deadlines, or legal records. Review stored reports during monthly audits. Update custom exclusions when policy changes. Small date choices can create large planning differences. Clear rules keep every team aligned well.

FAQs

What does days in between mean?

It means the number of days separating two dates. The answer can change when you include the start date, include the end date, or remove weekends and custom dates.

Should I include the start date?

Include the start date when that date is part of the counted period. Exclude it when you only need the elapsed gap after the starting day.

Should I include the end date?

Include the end date when the final date counts as an active day. Many rental, leave, and subscription periods count the final date.

Can this calculator count business days?

Yes. Turn on weekend exclusions and select the weekend days. You can also add holidays or closed dates as custom exclusions.

What format should custom excluded dates use?

Use YYYY-MM-DD format. You may separate dates with commas, spaces, semicolons, or new lines. Invalid dates are ignored.

Why is the raw day gap different?

The raw gap is the direct difference between dates. It does not follow your endpoint, weekend, or custom exclusion rules.

Are months and years exact?

No. Months and years are approximate because month lengths differ. The calculator uses average calendar values for quick planning estimates.

Can I save my result?

Yes. Use the CSV option for spreadsheet work. Use the PDF option for reports, records, quotes, and planning documents.