Altering a calculation based upon variable values from a drop down list

Hi Pete,

This works perfectly, however what formula would I need to alter the end date in column C accordingly?

Thanks in advance.

Put this in C2:

=IF(B2="","",B2+VLOOKUP(F2,AA$1:AD$2,4,0)+4)

then copy down.

Hope this helps.

Pete

Thanks Pete,

You are a star!