Dates finding

[SAN04]

Hello,

In attached template I want to write "1" in the red highlighted if "start and " finish" date is coming in between yellow highlighted month range.

For activity 1 i have done manually. Need formula for remaining activities.

If not is should write"0" in the cell.

This is required for all activity from 1 to 9.

Sheet attached for reference.

Thanks

 

[vletm]

SAN04
Use only number 1.

 

[SAN04]

Thanks Vletm

But i need to do Vice versa. I want put dates and accordingly the 1 should come in respective month

 

[vletm]

SAN04
Did Your sample file give a clear image?
You need to explain - what do You would like to need?