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:

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.

Alternatively, from Office 2013 onwards, you can use the =DAYS(end_date, start_date) function, which counts the calendar days between two dates.

Difference Between Calendar Days and Business Days

The difference between calendar days and business days lies in how days are counted. Calendar days include all days in the range. Business days count only working days: typically Monday to Friday (or Monday to Saturday, depending on the schedule); Sundays are always excluded.

For example, calculating the days between August 7 and August 17 (Friday to Monday), without including the start date, gives 10 calendar days and 6 business days (Monday–Friday). The two weekends are included in calendar days and excluded from business days.

How Many Business Days Are in a Month?

On average, a month has between 20 and 22 business days in a standard Monday-to-Friday schedule (around 21.7 business days per month) and between 24 and 26 days in a Monday-to-Saturday schedule, depending on the number of days in the month and weekend distribution.

How Many Business Days Are in a Year?

A standard calendar year has between 260 and 262 business days in a Monday-through-Friday schedule (52 full weeks plus 1 or 2 extra days), or between 312 and 314 working days in a Monday-through-Saturday schedule.