However which date functions to use depends on the amount of precision and the output format you want.
Suppose that we want to calculate the age of someone who is born on 15/06/1973 and we have his birth date in cell A1. If we want his age in whole number years only, e.g.
If instead you need the number of years between a date and the current date, replace one date with the TODAY function.
In the DATEDIF example above, try entering “=DATEDIF(B2, TODAY(),”y”)”.
40 years, then we can use this formula: The output of this formula will be as follows: 40 years, 2 months and 18 days.