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:
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.