How to calculate geomean by yearly, monthly and daily

[Anonymous]

I have these data:

COUNT	Year	Date
197	2019	10/2/2019
418	2019	10/1/2019
58	2019	9/30/2019
4	2019	9/29/2019
7	2019	9/28/2019
62	2019	9/27/2019
1745	2019	9/26/2019
823	2019	9/25/2019
170	2019	9/24/2019
1640	2019	9/23/2019
75	2019	9/22/2019
162	2019	9/21/2019
376	2019	9/20/2019
581	2019	9/19/2019
456	2019	9/18/2019
498	2019	9/17/2019
525	2019	9/16/2019
46	2019	9/15/2019
72	2019	9/14/2019
389	2019	9/13/2019
642	2019	9/12/2019
436	2019	9/11/2019
409	2019	9/10/2019
438	2019	9/9/2019
37	2019	9/8/2019
100	2019	9/7/2019
438	2019	9/6/2019
349	2019	9/5/2019
458	2019	9/4/2019
512	2019	9/3/2019
613	2019	9/2/2019
62	2019	9/1/2019
81	2019	8/31/2019
398	2019	8/30/2019
606	2019	8/29/2019
444	2019	8/28/2019
576	2019	8/27/2019
385	2019	8/26/2019
27	2019	8/25/2019
88	2019	8/24/2019
402	2019	8/23/2019
362	2019	8/22/2019
340	2019	8/21/2019
414	2019	8/20/2019
375	2019	8/19/2019
49	2019	8/18/2019
91	2019	8/17/2019
347	2019	8/16/2019
444	2019	8/15/2019
348	2019	8/14/2019
367	2019	8/13/2019
377	2019	8/12/2019
44	2019	8/11/2019
76	2019	8/10/2019
340	2019	8/9/2019
376	2019	8/8/2019
371	2019	8/7/2019
419	2019	8/6/2019
355	2019	8/5/2019
19	2019	8/4/2019
101	2019	8/3/2019
465	2019	8/2/2019
448	2019	8/1/2019
462	2019	7/31/2019
375	2019	7/30/2019
330	2019	7/29/2019
38	2019	7/28/2019
67	2019	7/27/2019
348	2019	7/26/2019
293	2019	7/25/2019
352	2019	7/24/2019
267	2019	7/23/2019
312	2019	7/22/2019
39	2019	7/21/2019
71	2019	7/20/2019
279	2019	7/19/2019
311	2019	7/18/2019
274	2019	7/17/2019
402	2019	7/16/2019
409	2019	7/15/2019
30	2019	7/14/2019
56	2019	7/13/2019
325	2019	7/12/2019
303	2019	7/11/2019
392	2019	7/10/2019
237	2019	7/9/2019
272	2019	7/8/2019
31	2019	7/7/2019
62	2019	7/6/2019
273	2019	7/5/2019
269	2019	7/4/2019
330	2019	7/3/2019
483	2019	7/2/2019
302	2019	7/1/2019
29	2019	6/30/2019
50	2019	6/29/2019
328	2019	6/28/2019
253	2019	6/27/2019
252	2019	6/26/2019
333	2019	6/25/2019
264	2019	6/24/2019
13	2019	6/23/2019
48	2019	6/22/2019
236	2019	6/21/2019
214	2019	6/20/2019
329	2019	6/19/2019
115	2019	6/18/2019
272	2019	6/17/2019
23	2019	6/16/2019
23	2019	6/15/2019
258	2019	6/14/2019
217	2019	6/13/2019
232	2019	6/12/2019
278	2019	6/11/2019
296	2019	6/10/2019

What i need is geometric mean yearly , monthly and daily. this image below is answer that i need. i tried follow it but still not work.

please anyone can help me? thank you in advanced.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

Here is my test file, but I couldn't find "date" table in the image. I created one, but the results are not satisfactory. You could find how to get the "date" table and get the correct result. 

[Anonymous]

Thank you for your solution.