The November report needs all activity on the 30th, including a record entered at 23:30. Use the start of December as the cutoff so the last day stays in scope.
Enter real dates and times
In A2:A5 enter October 31 at 23:50, November 1 at 00:00, November 30 at 23:30, and December 1 at 00:00, all in 2026. Put 3, 12, 8, and 7 in B2:B5. Set E2 to =DATE(2026,11,1) and E3 to =DATE(2026,12,1).

Illustrated timestamp boundaries. The next month’s first moment is outside the interval.
Check the start and the next month’s first moment
=SUMIFS(B2:B5,A2:A5,">="&E2,A2:A5,"<"&E3)Expect 20. The November 1 midnight record and the late November 30 record count. December 1 at midnight is outside the range. If an import yields a different result, check whether the timestamps are stored as text and whether they use the reporting time zone.

Illustrated reconciliation. Check the two exact midnight boundaries.



