View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sumeth Sumeth is offline
external usenet poster
 
Posts: 6
Default how to count 2 date columns conditions.

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