1. Select a blank cell for locating the elapsed years, months or days, and then click Kutools > Formula Helper > Date & Time helper.
2. In the Date & Time Helper dialog box, please configure as follows:
Go to the Age tab;
In the Date of Birth box, specify the date you will calculate elapsed years, months or days based on;
Check the Today option in the To section;
In the Output result type drop down list, select Year if you want to calculate the elapsed years; Tips: For calculating elapsed months, please choose Month from the drop-down For calculating elapsed days, choose Day from the drop-down.
Click OK. See screenshot:
3. Now you are getting the elapsed years, months or days from a certain date.
If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.