Day Counter: Calculate Days Between Two Dates

Free online day counter. Calculate the number of days between two dates or find out how many days have passed since a specific date. You can also count calendar and business days, weeks, and months.

Invalid start date.
Invalid end date.
End date must be on or after the start date.

Calendar days:

Business days (Mon–Fri):

Business days (Mon–Sat):

Weeks:

Months:

Years:

You might be interested in:

Add (Subtract) Days to a Date Time Card Calculator Hours and Minutes Calculator

How Many Days Since a Date?

Use the day counter to find how many days have passed since a specific date. Enter the past date as the "Start Date" and today's date as the "End Date". Here are some examples:

  • Start of the Month: days ago
  • Start of the Year: days ago
  • Last Christmas: days ago

How Many Days Until a Date?

Use the day counter to find how many days remain until a specific date. Enter today's date as the "Start Date" and your target date as the "End Date". Here are some popular countdowns:

  • Christmas: days left
  • New Year's Eve: days left
  • End of the Month: days left
  • FIFA World Cup 2030: days left
  • Halloween: days left
  • Valentine's Day: days left

How to Calculate Days Between Two Dates in Excel

To recreate a day counter in Excel or Google Sheets, use the =DATEDIF(start_date, end_date, "d") formula, where:

  • start_date: the cell reference containing your start date (e.g., A2).
  • end_date: the cell reference containing your end date (e.g., B2).
  • "d": tells Excel to return the difference in days. Use "m" for months or "y" for years.

For example, if A2 contains 01/15/2026 and B2 contains 03/20/2026, the formula =DATEDIF(A2, B2, "d") returns 64, the same difference in days that the day counter returns when the start date is not included. You can also subtract dates: =B2-A2.

Calendar Days vs. Business Days in a Day Counter

A day counter calculates the difference between two dates as calendar days or business days. Calendar days include every day—weekends, holidays, and workdays alike. Business days count the working days in the selected schedule: Monday through Friday or Monday through Saturday. Public holidays are not automatically excluded.

Calendar Days: A day counter includes every day in the selected date range. From January 1 to January 5, the result is 4 days when the start date is not included, or 5 when it is included.

Business Days: These count working days according to the selected schedule, either Monday through Friday or Monday through Saturday. Use the business-day results for work schedules, deadlines, and planning.

How Many Business Days Are in a Month?

On average, a month has between 20 and 23 business days, depending on the month's length, how weekends fall, and whether public holidays are excluded. The exact number changes every month and year, so use the day counter for a precise result.

Here's a general breakdown:

  • A typical month has about 20 to 23 weekdays (Monday through Friday), before public holidays are excluded.
  • February is the shortest month with around 20 weekdays. Months with 31 days can have up to 23 weekdays, depending on how the calendar falls.

For an exact count, use the day counter above: enter the first and last day of any month to get the precise number of business days. Check a work calendar specific to your country if you also need holiday adjustments.

How Many Business Days Are in a Year?

A standard year has between 260 and 262 weekdays (Monday through Friday). After public holidays are excluded, the exact number of working days depends on the country, employer, and work calendar.

  • With 52 weeks per year and 5 weekdays per week, the baseline is 260 weekdays. Depending on what day January 1 falls on, a year may have 261 or 262.
  • Public holidays, company holidays, and local calendars reduce the number of working days differently in each location. This day counter does not automatically exclude public holidays.
  • Many employers also offer paid time off (PTO), sick days, and company-specific holidays, which further reduce the number of actual working days.

To find the exact number of business days in any specific year, use the day counter above: enter January 1 and December 31 and check the Business Days (Mon-Fri) result.

Common Uses for a Day Counter and Date Calculator

A day counter is a practical date calculator for personal and professional situations that require the number of days between two dates:

  • Project Management: Use the day counter to calculate working days between milestones, sprints, and deadlines to keep your project on schedule.
  • HR & Payroll: Determine business days for employee leave requests, notice periods, probation periods, and PTO accrual.
  • Event Planning: Use the day counter to find out how many days remain before a wedding, conference, product launch, or other upcoming event.
  • Finance & Accounting: Calculate interest accrual periods, invoice due dates, payment terms (Net 30, Net 60, Net 90), and investment durations.
  • Legal Deadlines: Count calendar days or business days for filing deadlines, statute of limitations, contract terms, and regulatory compliance.

Whether you need to track deadlines, plan ahead, or count elapsed time, this day counter gives you calendar-day and business-day results in seconds.