# ExcelHelp with dates

#### Mang

I have two date columns:
A B C D E M N O
2019 2020
Jan Feb Mar .... Jan Feb Mar
Start Date End Date
3/1/20 3/1/20 X
3/1/20 3/10/20 X
3/4/20 3/4/20
3/4/20 3/20/20

I need to populate column O with X if the Month falls between Start and End Dates.
I have Dates for Months formatted in column M, N and O as 1/1/20, 2/1/20, 3/1/20
I tried using this formula but it misses the last 2 scenarios above.

IF(AND(O\$7>=\$A10, O\$7<=\$B10), "X","")

I have two date columns:
A B C D E M N O
2019 2020
Jan Feb Mar .... Jan Feb Mar
Start Date End Date
3/1/20 3/1/20 X
3/1/20 3/10/20 X
3/4/20 3/4/20
3/4/20 3/20/20

I need to populate column O with X if the Month falls between Start and End Dates.
I have Dates for Months formatted in column M, N and O as 1/1/20, 2/1/20, 3/1/20
I tried using this formula but it misses the last 2 scenarios above.

IF(AND(O\$7>=\$A10, O\$7<=\$B10), "X","")

I got it now so am good.
=IF(OR(AND(O\$7=DATE(YEAR(\$A10),MONTH(\$A10),1), O\$7<=\$B10),AND(O\$7>=\$A10, O\$7<=\$B10)), "X","")