Microsoft Project – field to show tasks due to finish this week

I was asked how to create a field that would show the text “Due this week” if the task was due to finish within the next week and leave it blank otherwise.

Go to the Project tab and in the Properties group, click Custom Fields.

Custom Fields dialog box

From the Type dropdown, select Text, select a relevant text field and click Rename to rename it to something suitable, such as Due this week. Click OK.

Click Formula.

The required formula is

IIf([Finish]-[Current Date]>=0 And [Finish]-[Current Date]<=7,”Due this week”,””)

Due Date formula

Click OK twice.

On your table, right-click over the column heading where you want to insert the new column, click Insert column and select the required column from the drop-down list.

You will then see all tasks that are due to finish within the next week.

Due Date field

Find out more about our Microsoft Project training London or our Microsoft Project training in Wiltshire, Hampshire and Dorset.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Project, Microsoft Project 2010, Microsoft Project 2013, Microsoft Project 2016 and tagged , , . Bookmark the permalink.

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s