July 4, 2019
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.
April 21, 2015
Hi Nur, welcome here on Mynda's Forum.
I examined your file and see two things:
1) You stated you inserted a drop down menu with three options in C2, but I can't find that. Only a 'hard' 20 (I suppose 20 working days for the first option of four weeks).
2) You put a formula in I2 that works correctly in my opinion.
So what's your question? 🙂
Because Excel can't know out of a date in column B if you want four, six or eight weeks time. What's the criterium for that?