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.
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.
The required formula is
IIf([Finish]-[Current Date]>=0 And [Finish]-[Current Date]<=7,”Due this week”,””)
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.