Frequency formula

[Johnboy28]

Hi, Can anybody tell me if you can add a date search to a Frequency formula?

Thank you

A	B	C	D	E	F	G	H	I	J
2	WE Date	Data
3	Sun 01/10/17	69		Weight	Sun 01/10/17	Sun 08/10/17	Sun 15/10/17	Sun 22/10/17	Sun 29/10/17
4	Sun 01/10/17	69		35	0
5	Sun 01/10/17	67		39	0
6	Sun 01/10/17	69		43	0
7	Sun 08/10/17	69		47	0
8	Sun 08/10/17	78		51	0
9	Sun 08/10/17	69		55	0
10	Sun 08/10/17	69		59	0
11	Sun 08/10/17	68		63	0
12	Sun 08/10/17	69		67	1
13	Sun 08/10/17	74		71	23
14	Sun 15/10/17	69		75	3
15	Sun 15/10/17	69		79	2
16	Sun 15/10/17	69		83	0
17	Sun 15/10/17	69		Total	4415	4416	4417	4418	4418
18	Sun 15/10/17	69
19	Sun 15/10/17	69			...=FREQUENCY(C3:C31,$E$4:$E$16)
20	Sun 22/10/17	69
21	Sun 22/10/17	75
22	Sun 22/10/17	69
23	Sun 22/10/17	74
24	Sun 22/10/17	68
25	Sun 22/10/17	69
26	Sun 29/10/17	69
27	Sun 29/10/17	69
28	Sun 29/10/17	69
29	Sun 29/10/17	69
30	Sun 29/10/17	78
31	Sun 29/10/17	69

<tbody>
</tbody>

 

[Gerald Higgins]

You can certainly use FREQUENCY with dates, although I'm not sure exactly what you're trying to do here.