# Age Average

1. ## Age Average

I Want To Know How To Calculate The Average Age Of Group Of People Working In An Project

2. Hi,

If ages are located in range A1:A20, use following ...
=Average(A1:A20)

3. It depends what information you have...

If you have dates of birth in B1:B10 for instance then one way to get the average age (in years)

=DATEDIF(AVERAGE(B1:B10),today(),"y")

4. ## Re: Age Average

OK that is helpful. what if i want to know average age in years and months? how would i do that?
THanks

5. ## Re: Age Average

hi and welcome to the forum :-)

unfortunately it is against forum rules to post a question in the thread of another member even if it seems related. please start your own thread and I suggest you post in a more appropriate forum here such as worksheet functions and formulas

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1