Count date in and out time

  • Thread starter Thread starter ibo
  • Start date Start date
I

ibo

Hi all

I have a spreadsheet about vendor analysis first column required order date
and others require received date.Is it possible to count delayed order in
one cell
and in time order on the other cell.I tried sumproduct but couldn't do it.

My data is shown below:

A B d1:2(out time) d2:3(in
time)

2 01.05.2003 10.05.2003
3 02.05.2003 03.05.2003
4 03.05.2003 03.05.2003
5 04.05.2003 04.05.2003
6 05.05.2003 03.05.2003


Note:I know if I would add new column let say C:B1-A1 and
D1=COUNTIF(C:C;">0") and D2= COUNTIF(C:C;"=<0") is it OK.

I would appreciate your help.

Thanks
 
=Sumproduct((A2:A6>=B2:B6)*1)
will give the number of in time orders

=Sumproduct((A2:A6<B2:B6)*1)
will give the number of delayed orders.

This assumes your cells actually are stored as dates.
 
Back
Top