right now I am working on writing up a sheet that I am using the sumifs function a lot in because it makes it simple to be able to add up cells on another sheet based on date. what I am looking to see if it is possible so that I don't have to go threw 53 different cells to change that date ranges for each formula so that it will calculate what I am looking for. ill be showing an example as reference

=SUMIFS(Daily!F:F,Daily!A:A,">=1/1/18",Daily!A:A,"<=1/7/18")
=SUMIFS(Daily!F:F,Daily!A:A,">=1/8/18",Daily!A:A,"<=1/14/18")
=SUMIFS(Daily!F:F,Daily!A:A,">=1/15/18",Daily!A:A,"<=1/21/18")

what I would like to have happen is for the dates to auto change when I drop down copy the formula threw the rest of the cells. I color changed what I would like to auto fill and change accordingly the date gap that is in these dates is the same gap that I am looking for basically for a years worth of weeks