Thanks for the reply. We have decided that for the 14 day selection the user will need to calculate themselves. They do not enter this very often, less than 1% of the time. I have the calculations working for the 7 day option however and I no longer get the error message.
I have attached a copy showing the idea. The calculations are still ...