I would like to run a formula across a spreadsheet to breakup data into weekly segments for a pivot table. I want to graph that data by the date of the last day for a week.
I want to make a week equal to Monday - Sunday. I can do this with a Weeknum function below.
=WEEKNUM("1/1/14", 2) to get a value of "1"
I need help with a formula where the value would represent the date of the Sunday at the end of the week. So in the example above, the result of "1" would be equal to 1/5/14. I would like to use this formula across a lot of data for an entire year so an ability to fill down is desired.