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.
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.
Jan 18, 2024 · Month 12 − Month 9 = 3 months in 2021. Month 6 − Month 1 + 1 = 6. So the number of months is 9. Multiply the average number of days in a month by our 9 months: 365.25/12 × 9 = 273.9375 days. Add the total number of days together and round the final answer: 18,627.75 + 273.9375 = 18,901.6875. Round down to get 18,901 — the number of days ...
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.
People also ask
How to calculate days between dates?
How do I find the difference between two days in Excel?
How many months are there between two dates?
How do I use the day calculator?
How many days between a month and a year?
What is day count & how does it work?
1. Choose the Start Date: Access the day calculator on the website. In the corresponding field, enter or select the start date. This can be today's date, a past date, or a future date, depending on your goal. 2. Set the End Date: After entering the start date, move to the end date field.
