I have a schedule with the following columns:

Start Date
Finish Date
Days Remaining

I have hundreds of tasks, but the final project completion is:

Open Date 8/4/2014

I would like to add a formula to the rows of key deliverables and some other milestones that shows the number of days or weeks (not sure what is available) remaining until the final project completion (which is the day we open).

Please let me know if you need other information