how to count 2 date columns conditions.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any one could help me pls.
I have a spreadsheet that I want to count records like this.

A B
Start Retile
1/1/2006 1/2/2007
1/1/2006 20/4/2007
15/6/2006 10/4/2007

I would like to count start is between 1/1/2006 to 31/3/2006 and
retile is between 1/1/2007 to 31/3/2007

Thank you so much
kim
 
=SUMPRODUCT(--(A2:A4>=DATEVALUE("1/1/2006")),--(A2:A4<=DATEVALUE("31/3/2006")),--(B2:B4>=DATEVALUE("1/1/2007")),--(B2:B4<=DATEVALUE("31/3/2007")))

Adjust ranges to real situation!
Regards,
Stefi


„Sumeth†ezt írta:
 
Thanks Stefi,
I try to use that formula and delete "--" but the result is zero.
I don't know why? can you tell me more about this.
Thanks so much
 
Don't delete "--", its an important part of the formula: forces to convert
logical values to numbers!

Stefi

„Sumeth†ezt írta:
 
Back
Top