vladimiratanasiu
Active Member
- Joined
- Dec 17, 2010
- Messages
- 346
- Office Version
- 2021
- 2019
- Platform
- Windows
Hello!
I have a list of a project with its associated subprojects. Each activity is allocated two cells, one for the time and the second for a short description of results. I need a formula to check horizontally each row with dates, or the whole table, to see if any date ( e.g. 02/06/2022, 16/07/2022 etc.) fits the checked period (e.g. 01/06/2022-31/05/2023). If it matches that period, I wish the associated subproject to be deleted from this table and moved in another file (e.g. Sheet 2).
Thank you!
I have a list of a project with its associated subprojects. Each activity is allocated two cells, one for the time and the second for a short description of results. I need a formula to check horizontally each row with dates, or the whole table, to see if any date ( e.g. 02/06/2022, 16/07/2022 etc.) fits the checked period (e.g. 01/06/2022-31/05/2023). If it matches that period, I wish the associated subproject to be deleted from this table and moved in another file (e.g. Sheet 2).
Thank you!
| Book1 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Date 1 | Date 2 | Activities | |||||||||||
| 2 | 01/06/2022 | 31/05/2023 | 1 | 2 | 3 | 4 | 5 | |||||||
| 3 | Subproject 1 | 02/06/2022 | ….... | 17/09/2022 | ….... | 15/12/2023 | ….... | x | ….... | x | ….... | |||
| 4 | Subproject 2 | 02/03/2022 | ….... | 16/07/2022 | ….... | 01/10/2022 | ….... | x | ….... | x | ….... | |||
Sheet1 | ||||||||||||||
