Excel calculate date and time: Add, subtract date time, time difference, age calculation
Kutools for Excel
Boosts Excel With 300+
Powerful Features
This tutorial introduces a powerful and helpful calculator which can solve almost 90% date and time calculations you probably use in Excel. It is the Date & Time Helper which is the one of features in Kutools for Excel.
What it can do are:
Calculate the difference between two dates or two times and return a specified format
Calculate the Age based on a given date and return to year, month, day or year month day
How to apply the Date & Time Helper feature
Applying the Date & Time Helper feature by clicking Kutools > Formula Helper > Date & Time Helper
 |  |  |
Add or Subtract date and time
If you want to add or subtract year, month or days, or hours, minutes or seconds to a date time, you can use the first and second options in the Date & Time Helper dialog.
1. Select a cell which you want to place the calculation result at, then click Kutools > Formula Helper > Date & Time Helper to enable the Date & Time Helper dialog.
2. In the Date & Time Helper dialog, check Add or Subtract option in the Type section.
3. Then in the Arguments input section, enter a date manually or click 
to select a date to calculate in the text box of Enter a date or select a date formatting cell.
4. Under Enter numbers or select cells which contain values you want to add (subtract), you can directly enter the numbers of year, month, week, day or hour, minute or seconds you want to add or subtract into the related textboxes, or you can select cells which contain the numbers you want to use to fill.
You can preview the formula and result in the Result section.
5. Click OK. Then the calculated result has been displayed. And then you can drag the auto fill handle down to the cells for applying the formula.
Add Date (2 years, 3 months, 12 weeks and 40 days)
Add date time (Add 3 days 3 hours 30 minutes and 15 seconds)
Subtract datetime (4 weeks 1 hour)
Calculate the difference between two dates or two times and return a specified format
If you want to get the difference between two dates or two times, you can use the Difference option in the Date & Time Helper dialog.
1. Select a cell which you want to place the calculation result at, then click Kutools > Formula Helper > Date & Time Helper to enable the Date & Time Helper dialog.
2. In the Date & Time Helper dialog, check Difference option in the Type section.
3. Then in the Arguments input section, enter dates manually or click to select dates to calculate in the text box of Date1 and Date2.
4. Under Output result type, you can choose the format you want the result display as from the drop-down list.
You can preview the formula and calculation result in the Result section.
Note: if you want to ignore the blank values, check Ignore (do not display) 0 values checkbox.
5. Click OK. Then the calculated result has been displayed. And then you can drag auto fill handle down to the cells for applying the formula.
Calculate the Age based on a given date and return to year, month, day or year month day
If you want to calculate the current age based on the birthday or a given date, you can choose the Age option.
1. Select a cell which you want to place the calculation result at, then click Kutools > Formula Helper > Date & Time Helper to enable the Date & Time Helper dialog.
2. In the Date & Time Helper dialog, check Age option in the Type section.
3. Then in the Arguments input section, do as below:
1) Enter a date manually or click to select a date to calculate in the text box of Date of Birth.
2) Check the end date as you need, if you want to calculate the current age, check Today, if you want to calculate the age on a specified date, check Specified date and then select the date cell.
3) Specify the result type as you need.
You can preview the formula and calculation result in the Result section.
4. Click OK. Then the calculated result has been displayed. And then you can drag the auto fill handle down to the cells for applying the formula.
Note：The Date & Time Helper supports Undo.
Demo: Excel calculate date and time: Add, subtract date time, time difference, age calculation
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
