Age Grouping Formula

[zinah]

Hi,

I have below fields, and what I need to do:

1. Add age grouping for each date of birth, is there any suggestions to accomplish that?
2. Is there any other way to calculate the age other than the formula I used in my example below? As you can see the formula did not give me the exact age as the Age field is showing

Thank you!

Age Grouping.xlsx
	A	B	C	D	E	F	G
1	Date of Birth	Age	Age Grouping	Age Calc.			Age Grouping
2	11/24/1978	43	35-45	44			18-25
3	11/4/1983	38	35-45	39			25-35
4	9/13/1975	46	45-55	47			35-45
5	6/28/1980	41	35-45	42			45-55
6	2/15/1975	47	45-55	47			55-65
7	9/15/1987	34	25-35	35			65-75
8	7/29/1984	37	35-45	38			75 and up
9	6/15/1975	46	45-55	47
10	4/24/1977	45	45-55	45
11	1/9/1981	41	35-45	41
12	9/3/1973	48	45-55	49
13	7/31/1967	54	45-55	55
14	10/22/1981	40	35-45	41
15	11/3/1982	39	35-45	40
16	1/7/1976	46	45-55	46
17	1/29/1983	39	35-45	39
18	2/23/1986	36	35-45	36
19	9/23/1973	48	45-55	49
20	8/15/1981	40	35-45	41
21	5/4/1984	38	35-45	38
22	8/25/1975	46	45-55	47
23	9/7/1984	37	35-45	38
24	7/2/1985	36	35-45	37
25	2/2/1977	45	45-55	45
26	8/6/1962	59	55-65	60
Sheet1

Cell Formulas
Range	Formula
D2:D26	D2	=(YEAR(NOW())-YEAR(A2))

 

[Gerald Higgins]

Hi, there are various ways of calculating the age, here's one way . . .

=ROUNDDOWN((NOW()-A1)/365.25,0)

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G
1	Date of Birth	Age	Age Grouping	Age Calc.		Low end	Age Grouping
2	11/24/1978	43	35-45	43		0	0-17
3	11/4/1983	38	35-45	38		18	18-25
4	9/13/1975	46	45-55	46		25	25-35
5	6/28/1980	41	35-45	41		35	35-45
6	2/15/1975	47	45-55	47		45	45-55
7	9/15/1987	34	25-35	34		55	55-65
8	7/29/1984	37	35-45	37		65	65-75
9	6/15/1975	46	45-55	46		75	75 and up
10	4/24/1977	45	45-55	45
11	1/9/1981	41	35-45	41
12	9/3/1973	48	45-55	48
13	7/31/1967	54	45-55	54
14	10/22/1981	40	35-45	40
15	11/3/1982	39	35-45	39
16	1/7/1976	46	45-55	46
17	1/29/1983	39	35-45	39
18	2/23/1986	36	35-45	36
19	9/23/1973	48	45-55	48
20	8/15/1981	40	35-45	40
21	5/4/1984	38	35-45	38
22	8/25/1975	46	45-55	46
23	9/7/1984	37	35-45	37
24	7/2/1985	36	35-45	36
25	2/2/1977	45	45-55	45
26	8/6/1962	59	55-65	59
Sheet6

Cell Formulas
Range	Formula
C2:C26	C2	=VLOOKUP(D2,$F$2:$G$9,2)
D2:D26	D2	=DATEDIF(A2,TODAY(),"y")

 

[zinah]

Hi, there are various ways of calculating the age, here's one way . . .

=ROUNDDOWN((NOW()-A1)/365.25,0)

Thank you so much, the formula worked!

 

[zinah]

Try:

Book1
	A	B	C	D	E	F	G
1	Date of Birth	Age	Age Grouping	Age Calc.		Low end	Age Grouping
2	11/24/1978	43	35-45	43		0	0-17
3	11/4/1983	38	35-45	38		18	18-25
4	9/13/1975	46	45-55	46		25	25-35
5	6/28/1980	41	35-45	41		35	35-45
6	2/15/1975	47	45-55	47		45	45-55
7	9/15/1987	34	25-35	34		55	55-65
8	7/29/1984	37	35-45	37		65	65-75
9	6/15/1975	46	45-55	46		75	75 and up
10	4/24/1977	45	45-55	45
11	1/9/1981	41	35-45	41
12	9/3/1973	48	45-55	48
13	7/31/1967	54	45-55	54
14	10/22/1981	40	35-45	40
15	11/3/1982	39	35-45	39
16	1/7/1976	46	45-55	46
17	1/29/1983	39	35-45	39
18	2/23/1986	36	35-45	36
19	9/23/1973	48	45-55	48
20	8/15/1981	40	35-45	40
21	5/4/1984	38	35-45	38
22	8/25/1975	46	45-55	46
23	9/7/1984	37	35-45	37
24	7/2/1985	36	35-45	36
25	2/2/1977	45	45-55	45
26	8/6/1962	59	55-65	59
Sheet6

Cell Formulas
Range	Formula
C2:C26	C2	=VLOOKUP(D2,$F$2:$G$9,2)
D2:D26	D2	=DATEDIF(A2,TODAY(),"y")

That is exactly what I need, thank you so much!

 

[Eric W]

Glad we could help! Thanks for the feedback.