Hi all,

I have a spreadsheet with various questions that will add a set number of days to an original date according to yes/no responses. However, I also need to add days in increments of 7 in response to a £value, ie: ‘Up to £5k’ adds 7 days; ‘>£5k to £10k’ adds 14 days, and so on, up to values of £500k. I need the formula to add the days to a date from a previous cell. All the formulas I’ve used to add days to yes/no answers work fine, but I’m pretty much a novice when it comes to excel and I have played about with the function but can’t get anything to work.

I hope this makes sense. Any suggestions are much appreciated.

​Hi all,I have a spreadsheet with various questions that will add a set number of days to an original date according to yes/no responses. However, I also need to add days in increments of 7 in response to a £value, ie: ‘Up to £5k’ adds 7 days; ‘>£5k to £10k’ adds 14 days, and so on, up to values of £500k. I need the formula to add the days to a date from a previous cell. All the formulas I’ve used to add days to yes/no answers work fine, but I’m pretty much a novice when it comes to excel and I have played about with the function but can’t get anything to work.I hope this makes sense. Any suggestions are much appreciated.  Read More

​