For the data below B1A1 is true.

A B
12/3/07 11:48 AM 12/3/07 1:26 PM

How do I check the dates are at least 1 day apart, or 24 hours apart?
I am looking for a check to inlcude in a sumproduct, using external sheet
reference, like:

SUMPRODUCT((SourceData!$A$1:$A$1000="Completed")*( ShippingData!$C$1:$C$1000-ShippingData!$D$1:$D$100001))

where C and D contain Scheduled date and Shipped date.

Also I am trying to avoid reformatting the source data or adding
suplementary, intermediate columns.

Thank you.