gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
I | J | K | L | M | N | |||
6 | 0 | 1 | 3 | 0 | ||||
7 | 1 | 2 | 4 | 5 | ||||
8 | 2 | 3 | 5 | 6 | ||||
9 | 7 | 4 | 6 | 7 | ||||
10 | 16-Nov-21 | 4 | 8 | 7 | 7 | 8 | ||
11 | 17-Nov-21 | 5 | ||||||
12 | 18-Nov-21 | 6 | ||||||
13 | 19-Nov-21 | 7 | ||||||
14 | 20-Nov-21 | 0 | ||||||
15 | 21-Nov-21 | 1 | ||||||
16 | 22-Nov-21 | 2 | ||||||
17 | 23-Nov-21 | 3 | ||||||
18 | 24-Nov-21 | 4 | ||||||
19 | 25-Nov-21 | 5 | ||||||
20 | 26-Nov-21 | 6 | ||||||
21 | 27-Nov-21 | 7 | ||||||
22 | 28-Nov-21 | 0 | ||||||
23 | 29-Nov-21 | 1 | ||||||
24 | 30-Nov-21 | 2 | ||||||
25 | ||||||||
26 | ||||||||
27 | ||||||||
28 | 16-Nov-21 | 8 | 7 | 7 | 8 | |||
29 | 30-Nov-21 | |||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K10:N10 | K10 | =COUNTIF($J$10:$J$24,K6)+COUNTIF($J$10:$J$24,K7)+COUNTIF($J$10:$J$24,K8)+COUNTIF($J$10:$J$24,K9) |
J10:J24 | J10 | =MOD(I10,8) |
K28:N28 | K28 | =K10 |
I need single formula in the Yellow Cell.
Basically I want to get number of days falling on specific category between two dates.
Input : From Date & To Date
Category : Mod(Date,8) = 0,1,2,3,4,5,6,7
Output : Number of days for each category.