"DKennedy" wrote:
.. I can use "IF" but once the "Today" dates
change to the following day
the data will be lost and only the current info will be present.
I want to capture historical data to graph.

Think we would need a subroutine to do the above
Formulas can only compute & return values in cells
To freeze the values returned would require vba (subroutines)
Afraid it's out of my depth to offer you this

Perhaps hang around awhile for insights from others versed in vba who might
step with something for you. Alternatively, you may wish to put in a new
post in .programming. Good luck !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--