Day Counter – Find Days Between Dates

Count the number of days between two dates using the date duration calculator below.

Days Between Start and End:

Total Days:
 
Business Days:
 
Weekend Days:
 
This calculation includes holidays in the business days result. Weekends include Saturdays and Sundays.
Learn how we calculated this below


On this page:


How to Find the Days Between Two Dates

Ever find yourself wondering how many days there are between two dates? You’re not alone, and that’s why we created the date duration calculator above.

This is also useful for finding the days until a holiday or birthday. There are a few different ways to find the days between dates.

Method One: Count the Days

The first method is to simply count the days on a calendar.

If the dates are in the same month, you can subtract the day of the month of the first date from the second.

Things get a little trickier if the dates are in different months or years. If the dates are in the same year, count the number of days in each month between the two dates, then count the remaining days in the month of the first date, and finally add the day of the month of the end date.

Date Duration Formula

Expressed as a formula, it might look something like this:

days = days in months between dates + remaining days in start month + days elapsed in the end month

For example, let’s find how many days are between June 25th and September 9th.

Start by finding the days in each month in between these dates.

July = 31 days
August = 31 days

Then, find the days remaining in the starting month. There are 30 days in June.

30 – 25 = 5 days remaining

Next, find the days elapsed in the first month.

September 9th = 9 elapsed days

Finally, let’s add it all up to find the total days in between.

31 + 31 + 5 + 9 = 76 days

This method becomes increasingly difficult the more time has elapsed between the two dates.

Method Two: Use Spreadsheet Software

You can use spreadsheet software such as MS Excel or Google Sheets to count days as well. Both pieces of software offer multiple ways to do this.

Both Excel and Sheets support using subtraction to calculate the days. To do this, enter the start date in cell A1 and the end date in cell A2. Then, enter a formula in cell A3: =A2-A1.

Excel also has a DAYS function that allows you to enter the two dates as arguments and will display the difference in days, just like using the subtraction method.

Method Three: Use a Calculator

The easiest method to calculate the days is to use a day counter like the one above or a time duration calculator. This method doesn’t require any special software and can quickly and accurately find the days between two dates.

This method also makes it easy to count workdays and weekends separately.

You might also be interested in our time calculator.