Enter a date in the calculator for an instant private answer. Live hours, minutes and seconds appear when the selected end date is today. Results use local calendar dates. Day totals are not a promise of exact elapsed clock hours.Choose your date
Calculate, compare and share
Count Monday-to-Friday dates between a chosen start and end date, while clearly distinguishing weekdays from local public holidays. This calculator supports transparent planning estimates.
What counts as a business day here?
The default working-day mode counts Monday through Friday, excluding Saturday and Sunday. It does not automatically remove bank holidays, national holidays or company-specific closures. Those require a country, region and holiday-year dataset that may change over time.
Does the calculator include the first date?
The standard day-difference convention excludes the start date. For example, Friday to Monday counts one intervening working-day boundary, Monday. Many spreadsheets use inclusive endpoints, which will count Friday and Monday as two weekdays. State the intended convention before comparing two totals.
Examples with weekends
From Friday, October 23, 2026 to Tuesday, October 27, 2026, the weekday dates after the start are Monday October 26 and Tuesday October 27. The tool therefore counts two weekdays. A pure calendar-date difference for the same endpoints is four days, demonstrating why the distinction matters.
Public holidays are not universal
December 25 may be a holiday in many places, but observed holidays can depend on local law, employer policies and whether the date falls on a weekend. Some countries work Sunday through Thursday. Our Monday–Friday estimator is not an authoritative employment or legal calendar.
How to use the answer for a project
Choose the first and last dates of the planned work interval, then record the weekday count alongside the dates and your jurisdiction’s holiday adjustments. For team planning, confirm the actual nonworking days with the organization before making service-level or contract commitments.
Excel and Google Sheets alternatives
Use =NETWORKDAYS(A1,B1) for inclusive Monday–Friday weekdays in many spreadsheet editions, or =NETWORKDAYS(A1,B1,HolidayRange) to subtract a defined holiday list. Note the difference between the spreadsheet’s inclusive endpoints and this tool’s default exclude-start calculation.
Need calendar days or full weeks instead?
The calendar date-difference tool counts Saturdays and Sundays, while the full-weeks tool groups elapsed days into seven-day blocks. Use those calculators when the requirement refers to literal calendar days rather than working days.
A seven-day range can contain five weekdays or fewer
Seven consecutive days always contain five weekdays under a standard Monday–Friday schedule, but an elapsed interval whose endpoints are counted differently may not produce the same number. For instance, if the start date is Monday and the end date is the following Monday, excluding the first Monday yields five weekdays. Inclusive counting would cover six Monday–Friday dates. Check endpoint rules before comparing the estimate with a timesheet.
Timezone and staffing considerations
Business-day planning is usually based on the workplace calendar, not the device clock of the person opening the website. A remote team can have members working in several timezones, and a Monday morning for one participant can still be Sunday elsewhere. Save the intended office timezone and the agreed holiday calendar in your project records. This particular tool remains a transparent Monday–Friday estimator.
Building a holiday-aware spreadsheet
When company closures matter, maintain a real list of nonworking dates and use it as a holiday-range argument in a spreadsheet function. Verify whether the function counts endpoints inclusively and whether each closure date is valid for your region. A formula that excludes weekends alone is not enough to enforce payroll, contract, court or regulatory deadlines, even if the weekday arithmetic is correct.
Checking a scheduling estimate before using it
After calculating Monday–Friday days, compare the result with a real working calendar. Confirm the team’s normal weekly days, any statutory or local holidays and any planned company closure. If the task is a contractual response deadline, check whether the relevant rule counts the day a notice is received. The page deliberately does not pretend to know your jurisdiction, because an apparently exact number can be misleading without those details.
An optional check is to list each date in the full table, label the weekday and mark the local closure dates yourself. The CSV can support that review, but it does not automatically subtract holidays. For international teams, save the jurisdiction and timezone as part of your scheduling assumptions. This makes the estimate easier for another person to reproduce.
Complete reference table
The consecutive-date table below includes every calendar day from your selected start. CSV export preserves all rows even when the on-screen search filters the view.
1–1500: every consecutive day
| Calendar date | Weekday | Day # | Remaining in year | Weeks + days | ISO week | Year completed |
|---|---|---|---|---|---|---|
| Click Display complete table to show all 1,500 rows. CSV export always contains the full dataset. | ||||||
For long-running personalized dates, the table recalculates from the currently selected start date. The 2026 progress guide stays on 2026; the evergreen day-of-year table follows the visitor-selected year.
Frequently asked questions
Does this count public holidays?
No. It counts Monday–Friday only; public holidays and company closures depend on the location.
How many weekdays lie between Friday and the next Tuesday?
Monday and Tuesday are counted when the Friday start date is excluded: two weekdays.
Does NETWORKDAYS return the same result?
NETWORKDAYS commonly includes both input dates; adjust for this tool’s exclude-start convention.
Does a weekend count as a working day?
Not in this Monday–Friday version. Other workweek arrangements require their own settings.