Need to display a count of occurences within a date range.

[QuickQuestion123]

Here is my issue. I have a large excel sheet with two columns of dates, one for begining Date and one for Ending date.

What I want to try and do is to have a specific date be entered in a cell and for a formula to be created to count all the occurences where that date falls inbetween the date ranges.

i.e.

Simple data of
Begining date Ending Date
05/01/06 07/01/06
07/01/06 12/01/06
04/01/06 05/05/06
01/01/06 12/01/06
06/01/06 06/05/06


if I display in the cell 6/1/06, than I should receive a count of 3.

I have been playing with the countif forumula but it just is not computing correctly.

ANY IDEAS????

Thanks - Ron

 

[Domski]

Hi,

Try this:

Book1
	A	B	C	D
1	Begining date	Ending Date
2	05/01/2006	07/01/2006
3	07/01/2006	12/01/2006
4	04/01/2006	05/05/2006
5	01/01/2006	12/01/2006
6	06/01/2006	06/05/2006
7
8
9
10	06/01/2006	3
Sheet3

Hope it helps.

 

[QuickQuestion123]

Domski,

Thanks, but just one small issue I failed to mention prior. The end date column may be blank if there is no current end date

so is there something that i can add to the forumla you mentioned to that it will still count an occurence if the Specific Date is Past the begining date, BUT there is no End date?

 

[QuickQuestion123]

Disregard, everyone.

Figured it out.

THANKS AGAIN!