Calculated Column: Items created this week

An short post about how to create a view displaying the  list items that are created this week:

Create a calculated column named WeekStart and add the following formula =[Created]-(WEEKDAY([Created])-1)

Create a calculated column named WeekEnd and add the following formula =[Created]+(7-WEEKDAY([Created]))

Now create a view where there’s a filter that [Today] is bigger than or equal to WeekStart and a filter that [Today ] is less than or equal to WeekEnd

Leave a Reply

Your email address will not be published.

*