EndOfWeekFilter.png

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I am trying to create a view that shows items for the current week. &nbsp;<br />
<br />
I found the following <a href="http://social.technet.microsoft.com/Forums/sharepoint/en-US/90cf63ca-0e9a-4130-b003-55f460e4590b/filter-items-for-only-this-week-and-next-week-in-a-list?forum=sharepointgeneralprevious" rel="ugc nofollow">site</a> that has a formula that captures the end of the current week in a date column. &nbsp; I modified it and created the following formula<br />
<b>=AssignToAnalyst+(6-WEEKDA<wbr />Y(AssignTo<wbr />Analyst))</b> &nbsp;The name of the calculated column is &quot;EndOfWeek&quot;<br />
<br />
The formula works great but I am having a hard time filtering the view to just show this week (2/10/2014 - 2/14/2014). I used the formula in my calculated column called &quot;EndOfWeek&quot;.<br />
<br />
I need to filter in this way &quot;EndOfWeek &gt;= AssignToAnalyst &amp;&amp;&nbsp;AssignToAnalyst &lt;= EndOfWeek&quot; something like that... Any ideas?<br />
<br />
Here's my site: <a href="http://isaac.issharepoint.com/Lists/Log/AllItems.aspx" rel="ugc">http://isaac.issharepoint.com/Lists/Log/AllItems.aspx</a>
</div>
</div>


Hi all,

I am trying to create a view that shows items for the current week.  

I found the following site (http://social.technet.microsoft.com/Forums/sharepoint/en-US/90cf63ca-0e9a-4130-b003-55f460e4590b/filter-items-for-only-this-week-and-next-week-in-a-list?forum=sharepointgeneralprevious) that has a formula that captures the end of the current week in a date column.   I modified it and created the following formula
=AssignToAnalyst+(6-WEEKDAY(AssignToAnalyst))  The name of the calculated column is "EndOfWeek"

The formula works great but I am having a hard time filtering the view to just show this week (2/10/2014 - 2/14/2014). I used the formula in my calculated column called "EndOfWeek".

I need to filter in this way "EndOfWeek >= AssignToAnalyst && AssignToAnalyst <= EndOfWeek" something like that... Any ideas?

Here's my site: http://isaac.issharepoint.com/Lists/Log/AllItems.aspx

Calculated Columns current week

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.