Hi there,

I have a "start date" cell and "end date" cell which contains dates. I'd like the start date to be dependant on what the user selects in a dropbox. For example, if the user selected YoY (Year on year), I'd like the start date to be the end date minus 1 yr. The end date I've inserted as =Today().

However, I'd also like to provide the user with the flexibility of manually inserting a date in that start date box without deleting the "IF" formula(for the dropbox flexibility) I'm going to use for the start date.

Many thanks.