PDA

View Full Version : Calculating Age



06-05-2001, 11:00 AM
After entering a birthdate, I would like to create a formula to calculate a persons age (in years) as at the current date.

06-05-2001, 12:22 PM
Murray,

To calculate age, use the formula =(NOW()-A1)/365, where A1 is their date of birth (dd/mm/yyyy).

To calculate their age from only the year of birth, use the formula =YEAR(NOW())-A1, where A1 is their year of birth (yyyy)