I have created a small spreadsheet holding details of birth dates of a group of people. I have tried to set it up such that whenever the sheet is opened it shows the current age of each person. I've basically used 3 columns for the date data. Col C is the date of birth, col D is today's date =NOW()and col E is their age =(D15-C15)/365 . This is all reasonably accurate except that it doesn't take into account leap years and when a date is firly close to someones birthday it can report the wrong answer for age, especially when we are talking of people, shall we say, of a certain age.
Any hints as to haow I can take leap years into account?
One more small teaser, there are 20 people on the list, how do I work out the average age and is it possible for the ages in your first formula to be given as number of years to 2dp as opposed to y m d?