How to calculate a lifetime in Excel
The formula DATEDIF calculates days, months or years between two dates:
= DATEDIF (<start date>, <end date>, unit)
The parameter unit can be:
- "M" - The number of complete (full) months in the period.
For example, to calculate a lifetime:
= DATEDIF (<start date>, TODAY (), “m”)