calculate age

Hello, Looking to calculate age ranges of people in an excel list, but it should only count the non-duplicated names. So for the example below, it should only count "Same Person" and "Other Same Person" once so that it does not give me a false record of people in that age range. I would like...

Could you please provide a formula that will calculate the end of the birth year in which a child reaches age 29? Trying to project the end of insurance coverage for dependents that reach maximum age. Coverage terminates at the end of the calendar year in which they reach age 29. Many thanks!!!

Hey all! I'm no EXCEL expert but can usually figure out less complicated formulas, however this one has me stumped. I'm working on a project which requires me to calculate a minor child (patient's) date of majority (when he or she turns 18), then add 3 years to that to arrive at a date at which...

Hello all, At the moment I have a rather clumsy way of calculating someone's age based on today. <tbody> B C D E F date of birth today year months answer <tbody> 06/05/2008 </tbody> =TODAY() =IF(MONTH(TODAY())>MONTH(B2),YEAR(TODAY())-YEAR(B2)...