Hi there,

I am working in an archive. I created an Excel file to control requests due date. Normally, we process requests either in 4 weeks, 6 weeks or 8 week. In my file I have various colums that give me different details. I want to create formula that counts the above parameters from the request date and automatically inserts in another colum.

For example: On 3 July 2019 John requested a digital copy of a rare book.

In colums A2 I record the Reference number / in colum B2 I insert the request date / in colum C2 I inserted a drop down menu with 3 options: 4 weeks, 6 weeks or 8 weeks to select / I want to colum C2 to have a formula that automatically counts one of the three options (4, 6 or 8 weeks) and gives me a date in I2.

Apologies for this but my knowledge of Excel is not in advance level to deal with such a complex situation and your helps is really appreciated.

I am sharing a file as an attachement and may be someone could give me feedback on how to deal with this.

Thank you and look forward to your reply.

Nour