Age Group Ranging by gender

[Raj1979]

Please assist in calculation of age ranges 5-9, 10-14, 15-19 etc. I have the date of births available in excel file.

gender	date of birth
F	04/08/2006
F	23/10/1975
M	27/03/1968
M	20/03/2013
M	28/05/1958
F	15/06/1960
M	19/01/2003
F	28/11/1962
M	10/03/1992
M	25/03/1979
F	25/09/1990
F	24/01/2019
M	04/04/1994
M	19/09/1954
M	02/03/1994
F	23/07/1998
F	21/01/1947
F	07/03/1990
F	30/12/1981
M	17/11/1996
M	02/05/1998
F	17/07/1982
M	17/11/1973
M	27/05/1986
M	31/01/1985
M	03/07/1965
F	10/01/1974
F	24/02/1997
M	08/02/1990
M	25/09/1976
F	17/10/1978
M	06/03/1970
F	07/08/1954
F	14/03/1974
M	07/12/1945
F	02/12/1952
F	18/05/1969
M	16/02/1993
F	23/06/1989
M	28/09/1959
F	03/01/1973
F	20/01/2001
F	10/02/1965
F	17/10/1979
F	30/12/1995
F	06/05/1995
M	17/12/1986
F	22/10/1988
F	17/08/2020
F	26/04/2002
F	25/05/2015
F	10/07/2010
F	03/11/1980
M	18/03/1993
F	28/04/1999
F	28/12/1957
F	20/03/1991
M	22/05/1986
M	15/10/2015
M	15/06/1957
F	15/08/1994
M	21/05/1992
F	29/06/1954
M	27/12/1989
F	07/01/1985
F	26/01/1991
M	17/03/1985
M	23/05/2005
M	25/05/1965
M	01/05/1977
F	17/04/1988
F	30/11/1975
M	03/08/1969
M	10/02/2004
M	01/10/1984
M	07/01/1987
M	18/01/1980
M	17/02/1987
M	13/12/1994
M	28/05/1997
M	21/06/1988
F	28/10/1979
M	25/01/1985
M	01/10/1977
F	21/03/1992

 

[AhoyNC]

Something like this?

Book2
	A	B	C	D	E	F	G	H	I	J
1	gender	date of birth	Age		Lower	Upper	Count		Gender	F
2	F	8/4/06	18		5	9	3			2
3	F	10/23/75	48		10	14	2			1
4	M	3/27/68	56		15	19	2			1
5	M	3/20/13	11		20	24	4			2
6	M	5/28/58	66		25	29	9			5
7	F	6/15/60	64		30	34	14			6
8	M	1/19/03	21		35	39	14			4
9	F	11/28/62	61		40	44	6			5
10	M	3/10/92	32		45	49	7			3
11	M	3/25/79	45		50	54	5			3
12	F	9/25/90	33		55	59	6			2
13	F	1/24/19	5		60	64	3			2
14	M	4/4/94	30		65	69	4			1
15	M	9/19/54	69		70	74	3			3
16	M	3/2/94	30		75	79	2			1
17	F	7/23/98	26		80	84	0			0
18	F	1/21/47	77		85	89	0			0
19	F	3/7/90	34		90	94	0			0
20	F	12/30/81	42		95	99	0			0
21	M	11/17/96	27
22	M	5/2/98	26
23	F	7/17/82	42
24	M	11/17/73	50
25	M	5/27/86	38
26	M	1/31/85	39
27	M	7/3/65	59
28	F	1/10/74	50
29	F	2/24/97	27
30	M	2/8/90	34
31	M	9/25/76	47
32	F	10/17/78	45
33	M	3/6/70	54
34	F	8/7/54	70
35	F	3/14/74	50
36	M	12/7/45	78
37	F	12/2/52	71
38	F	5/18/69	55
39	M	2/16/93	31
40	F	6/23/89	35
41	M	9/28/59	64
42	F	1/3/73	51
43	F	1/20/01	23
44	F	2/10/65	59
45	F	10/17/79	44
46	F	12/30/95	28
47	F	5/6/95	29
48	M	12/17/86	37
49	F	10/22/88	35
50	F	8/17/20	3
51	F	4/26/02	22
52	F	5/25/15	9
53	F	7/10/10	14
54	F	11/3/80	43
55	M	3/18/93	31
56	F	4/28/99	25
57	F	12/28/57	66
58	F	3/20/91	33
59	M	5/22/86	38
60	M	10/15/15	8
61	M	6/15/57	67
62	F	8/15/94	30
63	M	5/21/92	32
64	F	6/29/54	70
65	M	12/27/89	34
66	F	1/7/85	39
67	F	1/26/91	33
68	M	3/17/85	39
69	M	5/23/05	19
70	M	5/25/65	59
71	M	5/1/77	47
72	F	4/17/88	36
73	F	11/30/75	48
74	M	8/3/69	55
75	M	2/10/04	20
76	M	10/1/84	39
77	M	1/7/87	37
78	M	1/18/80	44
79	M	2/17/87	37
80	M	12/13/94	29
81	M	5/28/97	27
82	M	6/21/88	36
83	F	10/28/79	44
84	M	1/25/85	39
85	M	10/1/77	46
86	F	3/21/92	32
Sheet1

Cell Formulas
Range	Formula
G2:G20	G2	=COUNT(FILTER($C$2:$C$86,($C$2:$C$86>=E2)*($C$2:$C$86<=F2)))
J2:J20	J2	=COUNT(FILTER($C$2:$C$86,($C$2:$C$86>=E2)*($C$2:$C$86<=F2)*($A$2:$A$86=$J$1)))
C2:C86	C2	=DATEDIF(B2,TODAY(),"y")

 

[Raj1979]

Great, thanks for the assistance.