<div>
Much appreciated...worked well.
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
I want to make a week equal to Monday - Sunday. I can do this with a Weeknum function below.<br />
<br />
Example:<br />
=WEEKNUM(&quot;1/1/14&quot;, 2) to get a value of &quot;1&quot;<br />
<br />
Question:<br />
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 &quot;1&quot; 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.
</div>
</div>


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.

Example:
=WEEKNUM("1/1/14", 2) to get a value of "1"

Question:
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.

Can I get a formula for identifying the date of the last day of the week?

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.