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.

Well, without the specific of which cells, something like should work.

A1 - some date in the future when you want this to occur
B1 - value 1
C1 - value 2

Formula in D1 to trigger when the date in A1 arrives:

=if(TODAY()>=A1,C1-B1,"pending")

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"mfarino" wrote:

> 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.