Hi, I need some help with a date formula. I need the formula to output a '1' if the project falls within 2 dates specified.
1) Each project has a Start and End Date (column F and G)
2) I want the add a formula into the table cells that: Checks if the project Start and End dates fall within the Week commencing dates at the top in Row H7:T7.
3) Add a 1 if its within that date range so I can conditionally format
I have made a mock of of what I would expect for Project A showing 1's in the weeks the project is running
1) Each project has a Start and End Date (column F and G)
2) I want the add a formula into the table cells that: Checks if the project Start and End dates fall within the Week commencing dates at the top in Row H7:T7.
3) Add a 1 if its within that date range so I can conditionally format
I have made a mock of of what I would expect for Project A showing 1's in the weeks the project is running
Book3 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
5 | |||||||||||||||||||
6 | January | February | March | ||||||||||||||||
7 | Project Name | Start Date | End Date | 03/01/2022 | 10/01/2022 | 17/01/2022 | 24/01/2022 | 31/01/2022 | 07/02/2022 | 14/02/2022 | 21/02/2022 | 28/02/2022 | 07/03/2022 | 14/03/2022 | 21/03/2022 | 28/03/2022 | 04/04/2022 | ||
8 | Project A | 12/01/2022 | 18/02/2022 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | ||||||||
9 | Project B | 28/01/2022 | 30/04/2022 | ||||||||||||||||
10 | Project C | 15/01/2022 | 30/03/2022 | ||||||||||||||||
11 | |||||||||||||||||||
Sheet1 |