duration

The YEARFRAC function takes two dates and returns the years between them, including fractions of a year. You can optionally specify different methods of counting days. This function can be used to calculate someone’s age. An alternative to YEARFAC is DATEDIF which can return the difference between two days in years, months, or days. To … Read more