Date & Time Formula Wizard

Date & Time Formula Wizard is a formula builder for Microsoft Excel. It creates formulas to calculate the difference between two dates, add or subtract years, months, weeks, days or even hours, minutes and seconds.

Sure, you can write all the formulas yourself using Excel alone. The formula builder uses only Excel math and no custom worksheet functions. It just simplifies and accelerates this process,dramatically saving your time.

To add or subtract, first you should select the cell where you want to put the result. Then you run the add-in, enter the date or select a date cell and enter the quantity or select cells with years, months, weeks, days, hours, minutes and seconds. You will see the result of the calculation under Formula result. Click the Insert formula button. The formula will be inserted in the selected cell.

For more information, please see How to add and subtract dates in Excel.

If you need to calculate the difference between two dates, go to the Difference tab. There you will see three boxes to fill in: Date 1, Date 2 and Difference in. Unlike the Excel DATEDIFF function, our Date & Time Formula Wizard does not care about the order of the dates (start date and end date), it can output the result as a positive or negative number. After entering the dates, you select a format.

For instance, you can calculate the number of days between two dates; or show the difference in years, weeks and months; or weeks and days; etc. Once you click the Insert Formula button, the formula displayed in the Formula result section is inserted in the selected cell.

The detailed steps can be found here.

To create a formula to calculate age in Excel, switch to the Age tab. Select a cell with the birth date or enter it manually. Choose, whether you want to calculate age at today's date or a specific date. On the preview pane you will see the calculation result. Click Insert formula to get the Excel age formula inserted in your worksheet.

For more information, please see How to get age from birthdate.

The tool can calculate the difference between two dates in 15 formats:

1. Years
2. Months
3. Weeks
4. Days
5. Years + months
6. Years + weeks
7. Years + days
8. Months + weeks
9. Months + days
10. Weeks + days
11. Years + months + weeks
12. Years + months + days
13. Years + weeks + days
14. Months + weeks + days
15. Years + months + weeks + days

Sure. When calculating the date difference in two or more units, select the Add text labels option to make the result more understandable.

Yes. You can select a single unit in the Difference in box. Or, you can remove years and months from your calculations by selecting either the Exclude years or Exclude months option.