Calculate the number of Years between two Dates in Excel

Calculate the number of Years between two Dates using the YEARFRAC function in Excel.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excelshorts #exceltip #exceltrick

[sureshkrishnan]

Very much useful. But then how to format the two dates that suit this formula.

[Cosmos]

Explanation is so lucid and clear, anyone with basic English and logic could follow, understand and learn. Keep up the good work. Best wishes.

[samalbanese]

Question, I did what you have listed and I did get the fraction for the months, so how do I change it to a whole number for months? i.e., 1.2months vs a fraction

[bdtours]

How can we find 18 year age date from the birth date

[karthikkanigiri]

Can you explain how to check if a particular date is present or not in between 2 dates along with other parameters (ex:-Name, location and date is present or not in between two name, location and dates).

[rajeshakkineni]

Sir i want one more clarification if i need per example 27 years 3months 10 days like that.... What kind of formula i need to use

[rahuldhanger]

Can you explain me when date is same like that 01-01-2023 and 01-01-2023 how to count one.

[traderOP]

How to find remaining number of months

For example 1 april 2002 to 15 June 2022
It is approx 2.5 months

How can we calculate this in excel?

[bhavapritaapara]

Very very very useful.. to the point, quickly answered my question.. thank you very very much ❤
Subscribef

[SanuKumar_jsr]

Need to get hours elsaped between two date time stamps as duration, can you help

[santhiprakashb]

How to get no of days in each Month, between two dates?
For eg, 15th Oct 21 to 15th Dec 21
Then
Oct - 16 Days
Nov - 30 Days
Dec - 15 Days

What formula can be used to achieve this?

[Mikyda]

1 year and six days does not equate to 1.5 years. It should say aprox. 1.0164 years.