A
adimar
For the data below B1>A1 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$10000>1))
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.
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$10000>1))
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.