I've created an event planning project that explains all of the relevant tasks before, during, and after a given event in MS Project 2003. I would like to calculate the number of days between a given task and a task I've created called "Host Event". The best way I've been able to do it thus far is create a custom number column with a formula of:
Int([Project Finish]-8-[Start])
It essentially does the trick, as the "Host Event" task is 8 days away from the Project Finish date. However, this seems like bad coding because I hard-coded the 8 days and if I were to ever change any task durations after the "Host Event" task, it would completely throw off the formula.
Is there a better way that I can perform the following calculation?
Int([Project Finish]- ["Host Event" Start])