Rank items, select one start date, have remaining dates follow based on rank

R

rob normerica

I have a list of projects. I have one start date. Each project has a
varying amount of time to complete. I want the user to rank the
projects based on importance (example when it will ship) and then,
based on the individual times required to complete the rest of the
projects, excel will automatically generate start and complete dates
for the remaining projects. Need to know how to do this.
 
D

Debra Dalgleish

Assuming your rankings are in cells B2:B6, and start date is in a cell
named StartDate, enter the following formula in row 2, and copy down to
row 6:

=StartDate+SUMPRODUCT(--($C$2:$C$6<C2),--($B$2:$B$6))

Or, if you have the Analysis Toolpak installed, and want to use workdays
only:

=WORKDAY(StartDate,SUMPRODUCT(--($C$2:$C$6<C2),--($B$2:$B$6)))
 
Top