Calculator inputs
Formula used
Elapsed days: absolute difference between the end date and start date.
Inclusive days: elapsed days + 1 when both boundary dates count.
Between-only days: maximum of elapsed days - 1 and zero.
Business days: counted date range - selected weekends - holidays that fall on workdays.
Spreadsheet style: DAYS(end_date, start_date) for elapsed days. NETWORKDAYS.INTL(start_date, end_date, weekend_pattern, holidays) for workday logic.
How to use this calculator
- Select the start date and end date.
- Choose a counting method for boundary dates.
- Select calendar, business, or weekend days as the main result.
- Pick a weekend pattern. Use custom days when needed.
- Add holiday dates if they should be excluded from workdays.
- Enter an optional offset to find a future or past target date.
- Press the calculate button. Review the result above the form.
Example data table
| Start date | End date | Method | Weekend pattern | Expected use |
|---|---|---|---|---|
| 2026-01-01 | 2026-01-31 | Elapsed | Saturday and Sunday | Monthly project span |
| 2026-03-10 | 2026-03-20 | Inclusive | Friday and Saturday | Regional work schedule |
| 2026-06-01 | 2026-06-15 | Between dates only | Custom days | Boundary dates excluded |
Why day counts matter
Day counting seems simple at first. Yet real planning often needs more than one answer. A project may use calendar days. Payroll may use workdays. A contract may exclude weekends. A service level agreement may ignore listed holidays. This calculator handles those choices in one place. It also shows the supporting breakdown, so the result is easy to audit.
Flexible date range control
The start and end dates form the main range. You can count elapsed days, include both endpoints, or count only the dates between them. Elapsed mode works like many spreadsheet date functions. It measures the gap from the start date to the end date. Inclusive mode is useful for hotel stays, permits, events, and care periods. Between-only mode is helpful when the boundary dates should not be counted.
Business day logic
Work schedules vary by country and company. The weekend selector lets you use Saturday and Sunday, Friday and Saturday, Sunday only, or a custom pattern. You may also paste holiday dates. The calculator removes valid holidays from working day totals when those holidays fall on normal workdays. This keeps the business day count realistic for teams, deliveries, and milestones.
Advanced result details
The result card shows the selected total first. It also shows calendar days, business days, weekend days, and holiday exclusions. Extra conversions turn the selected total into weeks, hours, minutes, seconds, approximate months, and approximate years. These values help when you need to compare day counts with schedules, leases, interest periods, or operational plans.
Offset planning
Some tasks need a future or past target date. Enter an offset amount to move forward or backward from the start date. You can offset by calendar days or business days. Business offsets skip selected weekends and valid holiday dates. This is useful for deadline notices, approval windows, shipment promises, and maintenance planning.
Accuracy notes
Dates are calculated at midnight in the selected time zone. This avoids time-of-day drift. Calendar and business counts depend on the counting method you choose. Holidays must be entered as valid year-month-day values. Approximate month and year conversions use average lengths. They are helpful estimates, not legal billing rules. Always check contracts, labor policies, and local regulations when day counts affect money, rights, or compliance.
Practical uses
Use this tool for project plans, subscriptions, trials, school calendars, staffing, warranty periods, event schedules, and document deadlines. It is also helpful for learning spreadsheet-style date formulas. The formula panel explains the logic behind each answer. That makes the calculator useful for both quick results and careful verification.
Reading the output
Start with the highlighted total. Then review the breakdown beneath it. A large gap between calendar and business totals usually means many weekends or holidays were removed. Use the signed option when direction matters. Use absolute mode when only distance matters. Export the result when you need a saved record later.
FAQs
What does elapsed days mean?
Elapsed days measure the gap from the start date to the end date. The start date acts as the first boundary. The end date is not added as a full extra day.
When should I use inclusive counting?
Use inclusive counting when both boundary dates should count. It is useful for permits, care periods, stays, events, and timelines where the first and last dates are active days.
What does between dates only do?
Between-only mode removes both boundary dates. It counts only the dates inside the range. Use it when the start and end dates are markers, not counted days.
How are business days calculated?
Business days are counted after removing selected weekend days and valid holiday dates. A holiday removes a workday only when it falls on a day that is not already a weekend.
Can I use Friday and Saturday as weekends?
Yes. Choose the Friday and Saturday weekend pattern. You can also select custom weekend days if your organization follows a different weekly schedule.
How should I enter holidays?
Enter each holiday as YYYY-MM-DD. You can separate dates with commas, spaces, semicolons, or new lines. Invalid dates are ignored and shown as warnings.
Does the calculator handle reversed dates?
Yes. Absolute mode returns the positive distance. Signed mode returns a negative value when the end date is earlier than the start date.
What is the offset target date?
The offset target starts from the start date. It then adds or subtracts the entered number of calendar or business days, based on your selected options.
Are month and year values exact?
No. Month and year conversions use average lengths. They help with quick planning, but they should not replace exact monthly billing or legal calendar rules.
Why does timezone matter?
The selected time zone anchors each date at midnight. This avoids unwanted shifts when a server, user, or application uses a different regional setting.
Can I export the result?
Yes. Use the CSV button for spreadsheet records. Use the PDF button for a printable summary that includes the main result and supporting breakdown.