Basically, I've got a spreadsheet that has a range specified for each day of
the year. The formula is looking to subtract a previous date (2 weeks ago -
Nov 252007) from the latest range (today's date - Dec042007). **Dec042007 and
Nov252007 are named cell references**

As it stands now, I've got to do a find and replace each day so that the
data is current. I'd like to have a cell where I'd like to change daily that
would automatically change the formulas to the correct ranges. While the
find and replace works fine, it isn't as efficient as it could be.

Is this type of process possible? Can a formula be built off a table?

Thanks in advance.