How to calculate elapsed years, months, or days from a certain date in Excel?

For calculating the elapsed years, months or days based on a given date, the following methods can do you a favor.

Calculate elapsed years/months/days from a certain date with formula
Easily calculate elapsed years/months/days from a certain date with Kutools for Excel

Calculate elapsed years/months/days from a certain date with formula

As below screenshot shown, how to calculate the elapsed years, months or days based on a given date in cell A2?

Calculate elapsed years

Select a blank cell to output the elapsed years, enter the below formula into it and press the Enter key.

=YEAR(TODAY())-YEAR(A2)

Calculate elapsed months

Select a blank cell for locating the elapsed months, then enter the below formula into it and press the Enter key.

=DATEDIF(A2,TODAY(),"m")

Calculate elapsed days

Select a blank cell to place the elapsed days, enter formula into it and then press the Enter key.

=DATEDIF(A2,TODAY(),"d")

Calculate elapsed years/months/days from a certain date with Kutools for Excel

You can apply the Date & Time Helper of Kutools for Excel to easily calculate elapsed years, months or days with only several clicks.

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.

Related articles:

• How to convert birthdate to age quickly in Excel?