Calculate a
Person's Age in Excel
The DATEDIF() function in Excel calculates the number
of days, months, or years between two dates. This function makes it easy to
calculate a person's age. To try this:
- In a blank worksheet, type a birth date in cell A1, using slashes to
separate day, month, and year.
- In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.
The age (in years) will be displayed in cell A2.
|
