Calculated Columns current week

Hi all,

I am trying to create a view that shows items for the current week.  

I found the following site 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
LVL 5
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

seems to me that there is a little flaw in the EndOfWeek formula, since for the value Feb-15-2014 the EndOfWeek is calculated as Feb-14-2014.

In my tests, the formula works better with

=AssignToAnalyst+(7-WEEKDAY(AssignToAnalyst))

Open in new window

but there may be reasons why you prefer the formula you have in place.

In any case, to filter by the current week, the filter needs to compare today's date with the current week.

So you'd need these two filters, combined with AND

EndOfWeek is less than or equal to [Today]+6

EndOfWeek is greater than or equal to [Today]

End of week filter
cheers, teylyn
0
All Courses

From novice to tech pro — start learning today.