Hi
I have a dropdown box where the user must select a certain period (three , six , twelve months)
When the user select the option the formula needs to calculate the correct amount of days to add onto the input date.
Ex .
- if user selects three then the amount of days must be 91 that are added onto the date entered.
How would the formula look ?
any ideas ?