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?
This question is in the General Section. Responses must be helpful and on-topic.