Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
HI I have a list o people and there dates of birth, I have added a formulae
to add up their ages however I now want to simply analyse the dates as in how many 16 - 19 year olds 20 - 35 year olds etc etc Can anyone sugest a simple way to acomplish this ?? Thanks for help in advance |
#2
![]() |
|||
|
|||
![]()
Thanks
i will give it a try philkelly67 "Phil kelly" wrote in message ... HI I have a list o people and there dates of birth, I have added a formulae to add up their ages however I now want to simply analyse the dates as in how many 16 - 19 year olds 20 - 35 year olds etc etc Can anyone sugest a simple way to acomplish this ?? Thanks for help in advance |
#3
![]() |
|||
|
|||
![]()
Did you check the FREQUENCY worksheet function.
Mangesh "Phil kelly" wrote in message ... HI I have a list o people and there dates of birth, I have added a formulae to add up their ages however I now want to simply analyse the dates as in how many 16 - 19 year olds 20 - 35 year olds etc etc Can anyone sugest a simple way to acomplish this ?? Thanks for help in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
working with dates in fiscal years | Excel Worksheet Functions | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |