Vlook-up dates on the basis of category

I need help on the following:

(Ex A task is started on 30.01.2014 and i need target date of completion on the basis of below:

The above task is consists of 120 Metric Tons

Completion criteria is:

0-50 Metric Tons: 8 days
51-100 Metric Tons: 12 Days
101-150 Metric Tons: 16 Days.... so on

Pl. help.

Regards,
Nagesh.

completion.xlsx
hi,
attached is the solution I'm proposing.
AL

Thank you very much AL, in addition to the above, pl. help,

How the formulae will be when there are holidays (customized) in between.

Can anyone help on this please.

does this file ( http://wikisend.com/download/577450/completion.xlsx ) help ?
AL

Unable to download the file from the link.
Pl. help.

I don't manage to upload the file directly on this site.
It happens to me all the time, drives me crazy !

Pl. send to my e-mail: nagesh.tummalapalli@gmail.com.

Thanks in advance.
Nagesh.

ok , done.
pls let me know...