Well 'saying that' is easy enough:
=if(and( Sheet2!B2 <= date (2006,1,21), Sheet2!B3 =
date(2006,1,21)),Sheet2!B1,0).
And if you're okay with having a bunch of blank rows on Sheet1 where the
corresponding dates in Sheet2 did not meet the condition, then that construct
would work fine. But if you want to selectively copy the rows from Sheet2
that meet your condition, then I'd agree with the macro approach that Kostis
suggests.

"Mark B" wrote:

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)