Best excel formula to put daily data into weekly data?

I have a string of daily data (Dates in one column with data in subsequent columns assigned to the respective date) and i want to sum the data based on weeks to plot it. I want the week to start on Monday and end on Sunday. What is the most efficient way of doing this in excel?