Search results
Date Calculators. Time and Date Duration – Calculate duration, with both date and time included. Date Calculator – Add or subtract days, months, years. Weekday Calculator – What day is this date? Birthday Calculator – Find when you are 1 billion seconds old. Week Number Calculator – Find the week number for any date.
- Time Duration Calculator
Duration Between Two Dates – Calculates number of days; Date...
- Time Duration Calculator
Jan 1, 2024 · Nov. 11, 2025. Thanksgiving. Nov. 27, 2025. Christmas. Dec. 25, 2025. This free date calculator computes the difference between two dates. It can also add to or subtract from a date. Both can deal with business days and holidays.
- Overview
- Difference in days
- Difference in weeks
- Difference in months
- Difference in years
- Calculate age in accumulated years, months, and days
- Download our examples
- Other date and time calculations
- Related Topics
Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.
In this example, the start date is in cell D9, and the end date is in E9. The formula is in F9. The “d” returns the number of full days between the two dates.
In this example, the start date is in cell D13, and the end date is in E13. The “d” returns the number of days. But notice the /7 at the end. That divides the number of days by 7, since there are 7 days in a week. Note that this result also needs to be formatted as a number. Press CTRL + 1. Then click Number > Decimal places: 2.
In this example, the start date is in cell D5, and the end date is in E5. In the formula, the “m” returns the number of full months between the two days.
In this example, the start date is in cell D2, and the end date is in E2. The “y” returns the number of full years between the two days.
1. Use DATEDIF to find the total years.
In this example, the start date is in cell D17, and the end date is in E17. In the formula, the “y” returns the number of full years between the two days.
2. Use DATEDIF again with “ym” to find months.
In another cell, use the DATEDIF formula with the “ym” parameter. The “ym” returns the number of remaining months past the last full year.
3. Use a different formula to find days.
Now we need to find the number of remaining days. We'll do this by writing a different kind of formula, shown above. This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016). Here's how it does this: First the DATE function creates the date, 5/1/2016. It creates it using the year in cell E17, and the month in cell E17. Then the 1 represents the first day of that month. The result for the DATE function is 5/1/2016. Then, we subtract that from the original end date in cell E17, which is 5/6/2016. 5/6/2016 minus 5/1/2016 is 5 days.
You can download an example workbook with all of the examples in this article. You can follow along, or create your own formulas.
Download date calculation examples
Calculate between today and another date
As you saw above, the DATEDIF function calculates the difference between a start date and an end date. However, instead of typing specific dates, you can also use the TODAY() function inside the formula. When you use the TODAY() function, Excel uses your computer's current date for the date. Keep in mind this will change when the file is opened again on a future day. Please note that at the time of this writing, the day was October 6, 2016.
Calculate workdays, with or without holidays
Use the NETWORKDAYS.INTL function when you want to calculate the number of workdays between two dates. You can also have it exclude weekends and holidays too. Before you begin: Decide if you want to exclude holiday dates. If you do, type a list of holiday dates in a separate area or sheet. Put each holiday date in its own cell. Then select those cells, select Formulas > Define Name. Name the range MyHolidays, and click OK. Then create the formula using the steps below.
1. Type a start date and an end date.
In this example, the start date is in cell D53 and the end date is in cell E53.
Jan 18, 2024 · To use this days between dates calculator, you can: Click the calendar icon in the From field. Select the start date in the period you are trying to count. Use the arrow keys to change the year and month. Click the calendar icon in the To field. Choose the end date. In the Time between field, this answer will be expressed in days by default.
Jun 1, 2024 · There are 22 days between July 4th and July 26th. The calculation is: July 26th - July 4th = 22 days. If you want to include the end date, add 1 to get 23 days. So whether your dates are days, months or even years apart, this calculator makes it easy to count the span in between! Just enter the start and end dates.
You can use a leap year calculator to count the number of leap years between the days. To calculate the number of years from the days between the dates: Multiply the number of leap years by 365. Subtract the result from the number of days. Divide the remaining number by 365 and add it up with the number of leap years.
People also ask
How do I use the days between dates calculator?
How do I Count days between two dates?
How do you find the number of weeks between dates?
How do I find the difference between two days in Excel?
How do you calculate days separating two dates?
How many weeks are there between two dates?
After you select the start and end date, press the “Calculate” button. The result is 267 Days left (or 6,408 Hours / 384,480 Minutes / 23,068,800 Seconds). Calculate days between dates with incredible ease! Just enter the start date and end date and you will get a result with the total number of days between these dates.
