Excel Formula & Date Fixes

I have two Logbooks, I have populated the EXCEL spread sheet with 15 entry pages from a Google Sheets master that is continuous.

My problems are:
The totals do not agree and are off by 4.4 in the total ( think that this is within the MULTI-ENGINE DAY column)
The S column in the excel spreadsheet is not adding within the page and between the pages, this formula needs to mirror the other columns next to it.
The date heading at the top of each page is DD/MM/YYY when it needs to mirror the entries which are DD-MM-YYY

CHAT GPT says:
"The Two Main Errors:
Error #1: 31 Flights Excluded from Formulas (-34.80 hours)
Located in rows 2143-2157, 2189-2203, and 2212-2213
All September-December 2025 DH4 Q400 flights
These rows exist AFTER the SUM formula ranges end
Missing: 21.20 hrs (Day) + 13.60 hrs (Night)

Error #2: Non-Flight Data Included in Formulas (+32.60 hours)
SUM formulas are including "Totals Brought Forward" or other summary rows
Actual flights covered = 1,064.90 hrs
Grand Totals show = 1,097.50 hrs
Extra data = +32.60 hrs"

I think it may be wrong about the second error but the first error is probably the problem. I added two entries at rows 2132 + 2133 and it seems to have disrupted the formulas.

The largest thing is that the EXCEL spreadsheet needs to match the master logbook (google sheets) total.