I guess you're editing every sumifs formula manually

In C18 and filled down,

=SUMIFS('RA Data'!C:C,'RA Data'!$B:$B,">="&B18,'RA Data'!$B:$B, "<"&B18+1)

You could apply the same method to the other columns.

I'll also point out that this method is less prone to failure if you send the data to other users, bearing in mind that I'm using UK regional settings, with dates formatted as d/m/y, your method returns incorrect results when I open the sheet, this happens because the dates in your sumifs criteria are text strings, not real (numeric) dates.

For your MAX formula, try something on the lines of

=MAX(IF(INT('RA Data'!$B$2:$B$2521)=B18,'RA Data'!$C$2:$C$2521))

Which needs to be confirmed as an array formula by pressing Shift Ctrl and Enter, not just Enter.

Note that I have used a limited number of rows, not entire columns. Using entire columns would result in slow calculation and possible errors. If you need to allow for expansion of the data range then the use of dynamic ranges would be advisable.