EXCEL : Calculate the number of days, months, or years between two dates
The DATEDIF function can be used for this.
The syntax for the DATEDIF function is:
= DATEDIF ( start_date , end_date , unit )
• start_date – First or starting date (eg. DATE OF BIRTH)
• end_date – Second or last date (eg. TODAYS DATE)
• unit – Function to find the number of days (“D”), complete months (“M”), or complete years (“Y”) between the two dates.
Try it out.