Age Average
I Want To Know How To Calculate The Average Age Of Group Of People Working In An Project
Hi,
If ages are located in range A1:A20, use following ...
=Average(A1:A20)
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")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks