@bjsauer
With your dates in column A, just enter

=SUMIFS(Daily!F:F,Daily!A:A,">="&A2,Daily!A:A,"<"& A3)
and copy down.
The dates will adjust in line with the entries you have made for the date in each row.

Note:
One of your formulae must be just "<" and not "<=" otherwise you are duplicting the value being summed