I thought of another approach that you may consider:

- You might include a Lookup table with DATES and PRICE
- You would have to provide a column or range to indicate the date.
- Write a simple Lookup formula to lookup the price based on the date you supplied
- That way the approaches above would not be necessary and all of the formulas could be the same

This approach would be more difficult to set up but would be easier to follow once it is set up

Kirk