Hi experts. Hope you can help!

I have a data set as follows:

Store

Project 1

Project 2

Project 3

Project 4

Start

End

Start

End

Start

End

Start

End

Project Totals

Min Wk

Max Wk

1345

07/10/24

28/10/24

14/10/24

04/11/24

14/10/24

21/10/24

3

07/10/24

04/11/24

1111

07/10/24

28/10/24

1

07/10/24

28/10/24

981

04/11/24

11/11/24

07/10/24

28/10/24

21/10/24

11/11/24

04/11/24

11/11/24

4

07/10/24

11/11/24

2210

21/10/24

28/10/24

04/11/24

11/11/24

2

21/10/24

11/11/24

3401

07/10/24

28/10/24

1

07/10/24

28/10/24

What I want to do is after the Max WK column, add another that counts how many projects overlap in dates by store.

For example. Store 1345 has 3 projects in total and all 3 are overlapping in dates. Answer 3

Store 1111 only has one project and therefore naturally there are no other projects overlapping. Answer 0

Based on my column structure, is this possible?

Thanks for your help!

​Hi experts. Hope you can help! I have a data set as follows: StoreProject 1 Project 2 Project 3 Project 4     StartEndStartEndStartEndStartEndProject TotalsMin WkMax Wk134507/10/2428/10/24  14/10/2404/11/2414/10/2421/10/24307/10/2404/11/241111    07/10/2428/10/24  107/10/2428/10/2498104/11/2411/11/2407/10/2428/10/2421/10/2411/11/2404/11/2411/11/24407/10/2411/11/24221021/10/2428/10/24  04/11/2411/11/24  221/10/2411/11/243401  07/10/2428/10/24    107/10/2428/10/24 What I want to do is after the Max WK column, add another that counts how many projects overlap in dates by store. For example. Store 1345 has 3 projects in total and all 3 are overlapping in dates. Answer 3Store 1111 only has one project and therefore naturally there are no other projects overlapping. Answer 0 Based on my column structure, is this possible? Thanks for your help!  Read More

​