[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Calculated Columns current week

Posted on 2014-02-11
Medium Priority
607 Views
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
0
Question by:Isaac
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 39851427
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))
``````
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]

cheers, teylyn
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…