How to find number of years Between Two Dates

Finding No.of Years Between Two Dates

Here We are using Datedif( ) Function to finding Difference between Two Dates.

If we want to find No.of Months in between two dates then.

=DATEDIF(D2,B2,"M")

And For No.of Days

=DATEDIF(D2,B2,"D")

By using this function we can find Months in a year, Days in a Month also.

=DATEDIF(D2,B2,"YM")     -> Remaining Months After Years.

=DATEDIF(D2,B2,"MD")     -> Remaining Days After Months