2week look ahead

Hello,

Therre is a formulas for showwing the name of sucessor or predecessor filed in Ms-project spreedsheat.

Regards

FARES

Insert/show the Date1 field.

Right-Click on the heading of the Date1 column.

Click Customise Fields on the menu.

First Rename the Date1 field.

Call it "S Date" or similar, but you can’t use "Status Date" because that is a reserved name.

Then write the formula which just consists of one function, which is the Status Date.

You can just type it or get it from the list of functions with the function button.

[Status Date] is the last one under Project, Date.

Say we want the look-ahead to be 3 weeks ahead of the Status Date.

You can do the same thing similar for the Current Date.

Use a spare Date field, Date1, to store the Status Date.

Tools, Customise Fields, then Formula and Status Date is in Function,

Project.

Use another spare Date field, Date2, to store the [Status Date] +21



Once you have the boundaries of your date range stored in fields you can

make a Filter which is similar to the built-in Date Range Filter but which

gets its data from the fields instead of user input.

Make a Filter called "AA 3 Week Look-ahead".

Project, Filtered For, More Filters, New.

Filter like this:

Tasks whose Start is less than or equal to [Status Date] +21

And

Tasks whose Finish is greater than or equal to [Status Date]

Hi Alex,



In the past I have used a Date Range filter (or an adaptation) to achieve this. However, this shows the filtered tasks with their complete durations, regardless of the fact only a portion of the task happens during the timeframe specified in the Date Range filter.



For a quick view this is sometimes all you need, but you can also use the timescale option when printing to narrow down the field of view, so it just prints the two week window.



Regards,



Darren

as far as I know, there is no "Data Date Line" in MSP (i don’t know the latest versions)