Find the longest run of 0's in a column

Hi guys - new to this forum.

I have searched for this and cant find a previous solution.

I have a list of dates in column A (sequential from low to high).
I have corresponding rainfall data in column S.

I am trying to find the longest run of 0's in the rainfall data and return the start and end dates. It would be great if i could tell it (in cell C8) to find the longest run below this number.
ie: i say i want to find the longest run of numbers below 5.

I think the answer may be in an array formula but i dont know too much about them.

Thanks

Column A data
1/01/1987
2/01/1987
3/01/1987
4/01/1987
5/01/1987
6/01/1987
7/01/1987
8/01/1987
9/01/1987
10/01/1987
11/01/1987
12/01/1987
13/01/1987
14/01/1987
15/01/1987
16/01/1987
17/01/1987
18/01/1987
19/01/1987
20/01/1987
21/01/1987
22/01/1987
23/01/1987
24/01/1987
25/01/1987
26/01/1987
27/01/1987
28/01/1987
29/01/1987
30/01/1987
31/01/1987
1/02/1987
2/02/1987
3/02/1987
4/02/1987
5/02/1987
6/02/1987
7/02/1987
8/02/1987
9/02/1987
10/02/1987
11/02/1987
12/02/1987
13/02/1987
14/02/1987
15/02/1987
16/02/1987
17/02/1987
18/02/1987
19/02/1987
20/02/1987
21/02/1987
22/02/1987
23/02/1987
24/02/1987
25/02/1987
26/02/1987
27/02/1987
28/02/1987

Column S data
0.4
0
33.2
12.2
2.2
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1.2
2
0
2.2
1.8
0
0
0
0
0
0
0
0
0
0
0
0
0
0.2
0
0
0
0
0
0.2
0
0
0
0
3.6
40
0.2
0
0
1.6
0
0
11.4

Hope that helps.

(Thanks for the quick reply).

well that wins the prize for longest post i think a worksheet might actually be better !

hahaha - i couldnt work out how to attach it.

sorry!!

Spot on Domenic - i didnt think of doing it in another column and like your methodology.

I was overcomplicating it - trying to do in one formula - thanks for your logic.

Now if you can fix my watch ill be very impressed.