Thanks for the reply. The problem is I need this to update everytime a user
opens the file. It's not just me who will be looking at the data.

So there is no "easy" way to say this...?

=IF(Sheet2!B2<=01-21-06 AND Sheet2!B3=01-21-06,Sheet2!B1,0)