Sharepoint Calculated Column – Tasks Due This Week

By peter.stilgoe

WP Greet Box icon

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic.

Powered by WP Greet Box WordPress Plugin

To show tasks due this week, create the following 2 calculated columns:

Week start (Monday)

=[due date]-(WEEKDAY([due date],2)-1)

Week end (Friday)

=[due date]+(5–WEEKDAY([due date],2))

Create a view where:

Week start is less than or equal to [Today]

AND

Week end is greater than or equal to [Today]

More useful scenarios here:

http://www.myriadtech.com.au/blog/Alana/Lists/Posts/Post.aspx?ID=8

More From pstilgoe

calculated column , dates

categoria

Sharepoint Calculated Columns commento

commento

No Comments data

data

September 3rd, 2009

About... peter.stilgoe

This author published 482 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant

Share

No Comments

Previous post - Next post