Hi Mr Excel Team
In Below Table for "Item 1", Group "MS", and Task D, I need a formula that counts the number of dates that are within the week of Feb 14th 2022 (Feb 14 to Feb 20th both values included)
The result that I need to obtain is in Cell E12. In this case the result is 4 and it corresponds to the values higlighted in yellow
Note: Please note that some cells contain formulas and others not
In Below Table for "Item 1", Group "MS", and Task D, I need a formula that counts the number of dates that are within the week of Feb 14th 2022 (Feb 14 to Feb 20th both values included)
The result that I need to obtain is in Cell E12. In this case the result is 4 and it corresponds to the values higlighted in yellow
Note: Please note that some cells contain formulas and others not
| Book2 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 2 | MS | MS | SC | MS | PD | PD | MS | MS | |||
| 3 | D | R | A | D | R | A | D | R | |||
| 4 | Item1 | 15-Feb-2022 | 14-Feb-2022 | 18-Feb-2022 | 13-Feb-2022 | 7-Feb-2022 | 1-Feb-2022 | 9-Feb-2022 | 15-Feb-2022 | ||
| 5 | Item2 | 17-Feb-2022 | 16-Feb-2022 | 20-Feb-2022 | 15-Feb-2022 | 9-Feb-2022 | 3-Feb-2022 | 11-Feb-2022 | 17-Feb-2022 | ||
| 6 | Item1 | 21-Feb-2022 | 20-Feb-2022 | 24-Feb-2022 | 19-Feb-2022 | 13-Feb-2022 | 7-Feb-2022 | 15-Feb-2022 | 21-Feb-2022 | ||
| 7 | Item3 | 26-Feb-2022 | 25-Feb-2022 | 1-Mar-2022 | 24-Feb-2022 | 18-Feb-2022 | 12-Feb-2022 | 20-Feb-2022 | 26-Feb-2022 | ||
| 8 | Item1 | 4-Mar-2022 | 3-Mar-2022 | 7-Mar-2022 | 2-Mar-2022 | 24-Feb-2022 | 18-Feb-2022 | 17-Feb-2022 | 4-Mar-2022 | ||
| 9 | |||||||||||
| 10 | |||||||||||
| 11 | Item | Group | Task | Week of | Count | ||||||
| 12 | Item1 | MS | D | 14-Feb-2022 | 4 | ||||||
Sheet1 | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| I5:I8,B8:G8,B5:H7 | B5 | =P5+B4 |
