I'm currently trying to get a future date to auto populate.
Cell A: current date
Cell B: multiple drop down variable
Cell C: future date

I want the future date in cell C to auto populate based on the current date and whichever dropdown variable that's selected.

For ex,
Cell A: 13/10/2017
Cell B: banana
Cell C: 25/10/2017

Cell B will have several options to choose from in the drop down list and depending on what is selected will determine which future date will be auto populated.

Thanks for any help.