I am trying to get a result of a function to display in a cell based on the
system date. Once the date is passed, I would like to display the difference
in the two previous cells. I am using Excel 2007 to track changes, and there
are three key dates when I need the function to execute. I've been trying to
use the DATE and DATEVALUE functions, but can't quite seem to get what I am
looking for. thanks.