Creating a Monday through Sunday View in SharePoint

Office 365 / SharePoint Blog

In my previous post I explained how to easily create a current week’s view. But, what if you need the current week to show from Monday through Sunday?

In order to create a current week’s view with a specific day range, you need two additional fields in your list. For simplicity’s sake, we will call them WeekStart and WeekEnd. Both of these fields are calculated fields.

The WeekStart field has the following calculation: =[Start Date] – WEEKDAY([Start Date],2) + 1. You cannot copy and paste this formula directly into the field – you have to build it from scratch. You do so by typing the equal sign (=), then double-clicking on the date field you want it to calculate (e.g. Start Date), then type – WEEKDAY( and then double-click the date field again. You can then copy the ,2) + 1 portion into the calculation.

The WeekEnd field has the following calculation: =[WeekStart] + 6 which again, you will have to build from scratch by typing the equal sign (=), then double-clicking on the WeekStart field, then type + 6 to complete the formula.

You will notice that any existing data is automatically updated with these two calculated fields.

The next step is to create the view that only shows the current week.

To access the view options, click on the name of the list, and then from the LIST TAB at the top of the screen, select Create View if you want to create a new view, or Modify View if you want to change the current view.

Scroll down to the FILTER options for your view, and choose the WeekStart field and select “is less than or equal to” from the drop-down, and type [Today] in the value box. Next, choose the WeekEnd field and select “is greater than or equal to” from the drop-down, and type [Today] in the value box.

That will ensure that your list will only show you the data for the time between WeekStart and WeekEnd.

Advertisements

4 thoughts on “Creating a Monday through Sunday View in SharePoint”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s