Range that auto-adjusts depending on Value in Column C and D

[JohnTester]

Hello Ex-perts.

What the sheet must do.
In column B the number of eggs laid is counted. Once 4+ eggs are laid then the number of days is counted down from 24 in column E.
Should there be a hatchling then the formula should reset for the next 4+ and the count down started over.

I have the first set done but as soon as I re-enter new eggs laid it doesn't calculate at all.
Formula used in E is - =IF(SUM($D$5:D8)=0,IF(SUM($C$5:C8)>=4,$H$1-F7,0),0)
Formula used in F is - =IF(SUM($C$5:C8)>=4,1+F7)

The value of H1 is 24 (days)

As indicated by the yellow line. The total amount after the last 4 eggs has not been registered as a total of 4 to restart the formula.
What I need is something that will automatically re-adjust the range based on the last cell that contained a value both in C and D, respectively Or a macro.

 

[JohnTester]

Here is the XL2BB.

The range should have adjusted to pick up the new value of 4 in column C.

2. February Breeding.xlsx
	A	B	C	D	E	F	G
1	Hok1
2	DATE		Amount of Eggs	Total Babies	Days to go	Days passed	COMMENTS AND OBSERVATIONS
3
4
5	Mon-31-Jan-22			0	0	0
6	Tue-01-Feb-22				0	FALSE
7	Wed-02-Feb-22		1		0	FALSE
8	Thu-03-Feb-22		1		0	FALSE
9	Fri-04-Feb-22		1		0	FALSE
10	Sat-05-Feb-22		1		24	1
11	Sun-06-Feb-22				23	2
12	Mon-07-Feb-22				22	3
13	Tue-08-Feb-22				21	4
14	Wed-09-Feb-22				20	5
15	Thu-10-Feb-22				19	6
16	Fri-11-Feb-22				18	7
17	Sat-12-Feb-22				17	8
18	Sun-13-Feb-22				16	9
19	Mon-14-Feb-22				15	10
20	Tue-15-Feb-22				14	11
21	Wed-16-Feb-22		4		13	12
22	Thu-17-Feb-22				12	13
23	Fri-18-Feb-22				11	14
24	Sat-19-Feb-22				10	15
25	Sun-20-Feb-22				9	16
26	Mon-21-Feb-22				8	17
27	Tue-22-Feb-22				7	18
28	Wed-23-Feb-22				6	19
29	Thu-24-Feb-22				5	20
30	Fri-25-Feb-22				4	21
31	Sat-26-Feb-22				3	22
32	Sun-27-Feb-22				2	23
33	Mon-28-Feb-22				1	24
34	Tue-01-Mar-22				0	25
35	Wed-02-Mar-22				-1	26
36	Thu-03-Mar-22				-2	27
37			8	0
Hok1

Cell Formulas
Range	Formula
A1	A1	=MID(CELL("filename",B3),FIND("]",CELL("filename",B3))+1,31)
C5	C5	=IF('[1. January Breeding.xlsx]Hok1'!$F$36<=0," ",'[1. January Breeding.xlsx]Hok1'!$C$37)
D5	D5	='[1. January Breeding.xlsx]Hok1'!$D$37
E5	E5	=IF(E6-1<=0,0,E6+1)
F5	F5	=IF('[1. January Breeding.xlsx]Hok1'!$F$36<=0,0,'[1. January Breeding.xlsx]Hok1'!$F$36)
E6:E36	E6	=IF(SUM($D$5:D6)=0,IF(SUM($C$5:C6)>=4,$H$1-F5,0),0)
F6:F36	F6	=IF(SUM($C$5:C6)>=4,1+F5)
A5	A5	='Over View'!C42-1
A6	A6	='Over View'!C42
A7:A36	A7	=A6+1
C37:D37	C37	=SUM(C6:C36)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G5,D5:E5,A5	Expression	=OR(WEEKDAY($A$5)=1,WEEKDAY($A$5)=7)	text	NO
A6:G6	Expression	=OR(WEEKDAY($A$6)=1,WEEKDAY($A$6)=7)	text	NO
A36:D36,F36:G36	Expression	=OR(WEEKDAY($A$15)=1,WEEKDAY($A$15)=7)	text	NO
A35:G35	Expression	=OR(WEEKDAY($A$14)=1,WEEKDAY($A$14)=7)	text	NO
A34:G34	Expression	=OR(WEEKDAY($A$13)=1,WEEKDAY($A$13)=7)	text	NO
A33:D33,F33:G33	Expression	=OR(WEEKDAY($A$19)=1,WEEKDAY($A$19)=7)	text	NO
A32:D32,F32:G32	Expression	=OR(WEEKDAY($A$18)=1,WEEKDAY($A$18)=7)	text	NO
A31:D31,F31:G31	Expression	=OR(WEEKDAY($A$17)=1,WEEKDAY($A$17)=7)	text	NO
A30:D30,F30:G30	Expression	=OR(WEEKDAY($A$16)=1,WEEKDAY($A$16)=7)	text	NO
A29:D29,F29:G29	Expression	=OR(WEEKDAY($A$15)=1,WEEKDAY($A$15)=7)	text	NO
A28:G28	Expression	=OR(WEEKDAY($A$14)=1,WEEKDAY($A$14)=7)	text	NO
A27:G27	Expression	=OR(WEEKDAY($A$13)=1,WEEKDAY($A$13)=7)	text	NO
A26:D26,F26:G26	Expression	=OR(WEEKDAY($A$19)=1,WEEKDAY($A$19)=7)	text	NO
A25:D25,F25:G25	Expression	=OR(WEEKDAY($A$18)=1,WEEKDAY($A$18)=7)	text	NO
A24:D24,F24:G24	Expression	=OR(WEEKDAY($A$17)=1,WEEKDAY($A$17)=7)	text	NO
A23:D23,F23:G23	Expression	=OR(WEEKDAY($A$16)=1,WEEKDAY($A$16)=7)	text	NO
A22:D22,F22:G22	Expression	=OR(WEEKDAY($A$15)=1,WEEKDAY($A$15)=7)	text	NO
A21:G21	Expression	=OR(WEEKDAY($A$14)=1,WEEKDAY($A$14)=7)	text	NO
A20:G20	Expression	=OR(WEEKDAY($A$13)=1,WEEKDAY($A$13)=7)	text	NO
A19:D19,F19:G19	Expression	=OR(WEEKDAY($A$19)=1,WEEKDAY($A$19)=7)	text	NO
A18:D18,F18:G18	Expression	=OR(WEEKDAY($A$18)=1,WEEKDAY($A$18)=7)	text	NO
A17:D17,F17:G17	Expression	=OR(WEEKDAY($A$17)=1,WEEKDAY($A$17)=7)	text	NO
A16:D16,F16:G16	Expression	=OR(WEEKDAY($A$16)=1,WEEKDAY($A$16)=7)	text	NO
A15:D15,F15:G15	Expression	=OR(WEEKDAY($A$15)=1,WEEKDAY($A$15)=7)	text	NO
A14:G14	Expression	=OR(WEEKDAY($A$14)=1,WEEKDAY($A$14)=7)	text	NO
A13:G13	Expression	=OR(WEEKDAY($A$13)=1,WEEKDAY($A$13)=7)	text	NO
A12:D12,F12:G12	Expression	=OR(WEEKDAY($A$12)=1,WEEKDAY($A$12)=7)	text	NO
A11:D11,F11:G11	Expression	=OR(WEEKDAY($A$11)=1,WEEKDAY($A$11)=7)	text	NO
A10:D10,F10:G10	Expression	=OR(WEEKDAY($A$10)=1,WEEKDAY($A$10)=7)	text	NO
A9:D9,F9:G9	Expression	=OR(WEEKDAY($A$9)=1,WEEKDAY($A$9)=7)	text	NO
A8:D8,F8:G8	Expression	=OR(WEEKDAY($A$9)=1,WEEKDAY($A$9)=7)	text	NO
A7:G7	Expression	=OR(WEEKDAY($A$7)=1,WEEKDAY($A$7)=7)	text	NO
A6:G6	Expression	=OR(WEEKDAY($A$6)=1,WEEKDAY($A$6)=7)	text	NO

 

[JohnTester]

No help is needed. Sorted it out with the Max formula.
eg. IF((MAX($E$5:E8)-MAX($F$5:F8))<0,0,(MAX($E$5:E8)-MAX($F$5:F8)))