LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count pieces of records meet conditions in different columns Amy Excel Worksheet Functions 1 July 19th 07 10:39 AM
Count with 2 conditions, second one OR [email protected] Excel Worksheet Functions 2 June 4th 06 05:55 PM
count all the columns in a range with certain conditions hopeace Excel Discussion (Misc queries) 3 October 18th 05 08:38 PM
Count with 2 conditions? Lee Excel Worksheet Functions 2 March 19th 05 02:45 AM
count number of cells based on TWO conditions (2 different columns Troi-Xanh Excel Worksheet Functions 2 February 12th 05 12:46 AM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"