If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.

To calculate someone's age in Excel, enter the formula =DATEDIF (A2,TODAY ()," y"), where cell A2 contains the date they were born and "Today" is today's date. Press Enter, and Excel will output ...