I may be jumping in late, but wouldn't

=INT(A1-7/24)=(TODAY()-1)

do the same thing (after correcting the "--7:00;00" to --"7:00:00")?

In article ,
"Bob Phillips" wrote:

Can you adapt this to what you want

=IF(OR(AND(INT(A1)=TODAY()-1,A1-INT(A1)=--"07:00:00"),AND(INT(A1)=TODAY(),A
1-INT(A1)<"--7:00;00")),TRUE,FALSE)

basically it tests A1 to be either
yesterday and time 7:00AM or later OR
today and time earlier than 7:00AM

It assumes A1 has date and time