QuickQuestion123
New Member
- Joined
- Mar 21, 2006
- Messages
- 15
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
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