Formula to look between 2 dates

[Eurekaonide]

Hi
Wonder if you can help please.
I have a table with the months running along the top one month to each column (it defaults to the 1st of each month) so I have also added in above it the last day of each month.
so in column c row 1 it would say 31/10/2022 and in column c row 2 it would say 01/10/2022
Now in Row 3 column A is my start date and column B is an end date

what I want is for a formula to place a 1 in the C column (onwards) if the start date is between 1st-31st October and to place a 1 if the end date is between these dates.
this is so that each month it will show either a blank or a 1 depending on when something starts and finishes.

I had this but it doesnt seem to work

=IF(AND(A3<=C2,B3>=C1),1,"")

any help appreciated thanks

 

[Eurekaonide]

I think I may have solved it, would appreciate your feedback and thoughts.

=IF(OR(C$2>=$A3,C$1<=$A3,C$2>=$B3),0,1)

Scrap that its not working in future months.

 

[Eurekaonide]

That formula does not give the same results as post#13 which you said was correct.

Yes I know now - I give up I cant get it to work at all!

 

[Fluff]

Can you post some sample data using the XL2BB add-in that show the problem.

 

[awoohaw]

Yes I know now - I give up I cant get it to work at all!

Also, if you can re-visit post 7, the requirements for the different scenarios. I think I had a future scenario in there. And if you can add a future column for 1 Nov to 30 Nov and the expectations it could help as well.

But a worksheet snippet that @Fluff suggests is also something that can help.