How do I get a function to execute on a specific date in Excel?

[mfarino]

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.

 

[JBeaucaire]

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")