I need help. I need to calculate a series of dates that action items need to be completed, based on a future date. The future date could be a year out, or two weeks out, but the series of completion dates need to be proportional. That's where I am getting stuck.

For instance, if I have a future completion date of 12/31/11

Item A needs to be completed by x date
Item B needs to be completed by y date
Item C needs to be completed by z date


This formula needs to work regardless of how far or near the completion date is, so I am thinking a percentage of time left may be needed? An ideal time line would be over the course of one year. But if the completion date is sooner, the spreadsheet needs to automatically adjust to accommodate the amount of time left. Any thoughts on how I can make this work?

Thanks!