I am trying to get the count the number of occurances between date ranges. Is this the best way or is there a better way?
The formula is returning 0... i tried counta but that returns the number of rows in the array.
The formula is returning 0... i tried counta but that returns the number of rows in the array.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
1 | Time Requested | Requested ETC | Actual ETC | Closed | Tech Time | Related | ||||||
2 | 1/2/06 13:30 | 1/4/06 13:00 | NULL | 1/3/06 17:00 | 0 | Other | Other | |||||
3 | 1/2/06 17:29 | 1/4/06 13:00 | NULL | 1/3/06 1:00 | 0 | PrePro | PrePro | 2/10/06 0:00 | 0 | |||
4 | 1/3/06 8:21 | 1/3/06 11:30 | NULL | 1/3/06 11:00 | 1 | Conversion | Conversion | |||||
5 | 1/3/06 10:28 | 1/3/06 18:00 | NULL | 1/3/06 17:15 | 0 | Conversion | Prod Engineering | |||||
6 | 1/3/06 11:19 | 1/3/06 16:00 | NULL | 1/3/06 12:00 | 0 | Other | Export | |||||
7 | 1/3/06 12:27 | 1/3/06 16:00 | NULL | 1/3/06 17:30 | 0 | Other | Audit | |||||
8 | 1/3/06 12:41 | 1/3/06 16:00 | NULL | NULL | 0 | Prod Engineering | Staging | |||||
9 | 1/3/06 12:41 | 1/4/06 1:00 | NULL | NULL | 0 | Export | ||||||
10 | 1/3/06 12:50 | 1/4/06 15:00 | NULL | 1/3/06 17:00 | 0 | Other | ||||||
11 | 1/3/06 13:18 | 1/3/06 14:00 | 1/3/06 16:00 | 1/3/06 16:00 | 0 | PrePro | ||||||
12 | 1/3/06 13:21 | 1/3/06 14:00 | 1/3/06 15:00 | 1/3/06 15:00 | 0 | PrePro | ||||||
13 | 1/3/06 13:34 | NULL | NULL | 1/3/06 14:30 | 0 | Audit | ||||||
14 | 1/3/06 13:39 | NULL | NULL | 1/3/06 14:15 | 0 | Audit | ||||||
15 | 1/3/06 13:58 | 1/3/06 17:00 | NULL | 1/6/06 22:30 | 2 | Conversion | ||||||
16 | 1/3/06 14:05 | 1/3/06 15:00 | NULL | 1/3/06 17:00 | 1 | Audit | ||||||
17 | 1/3/06 15:39 | 1/3/06 19:00 | NULL | 1/3/06 15:45 | 0 | Other | ||||||
18 | 1/3/06 15:41 | 1/3/06 17:00 | NULL | 1/18/06 16:00 | 0 | Staging | ||||||
19 | 1/3/06 16:16 | 1/4/06 10:00 | 1/4/06 15:00 | 1/4/06 15:00 | 2 | PrePro | ||||||
20 | 1/3/06 16:18 | 1/3/06 18:00 | NULL | 1/3/06 17:00 | 0 | Audit | ||||||
21 | 1/3/06 17:45 | 1/4/05 15:00 | NULL | 1/5/06 19:00 | 0 | Other | ||||||
Sheet1 |