Display days until a milestone in MS Project

[DaveC]

How do I capture the number of days remaining before a milestone in MS
Project. Ideally, I would like to look at the Gantt view and see my
milestone with the date displayed AND the days remaining from current date.

 

[Jack Dahlgren]

Insert a text field and create a custom formula for it.

I'd suggest the following formula:

projdatediff(Date(),[Finish])/[Minutes Per Day]

To do this:

Insert the text field you want.
Rightclick the column header and choose customize
click the formula button
paste in the formula
click OK until you are back at the main screen

-Jack Dahlgren

 

[DaveC]

Thanks Jack!! I wanted to capture the total calender days remaining, so I
ended up using the following:

DateDiff("d",Date(),[Finish])

The projectdatediff() function removed non working days from the total.

Thanks for pointing me in the right direction.
-Dave

Insert a text field and create a custom formula for it.

I'd suggest the following formula:

projdatediff(Date(),[Finish])/[Minutes Per Day]

To do this:

Insert the text field you want.
Rightclick the column header and choose customize
click the formula button
paste in the formula
click OK until you are back at the main screen

-Jack Dahlgren

How do I capture the number of days remaining before a milestone in MS
Project. Ideally, I would like to look at the Gantt view and see my
milestone with the date displayed AND the days remaining from current
date.

 

[DaveC]

Thanks Trevor!! I used your suggestion and it worked great.

-Dave