Excel Help with dates

M

Mang

Joined
Jul 9, 2019
Messages
3
Reaction score
1
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","")
 
Mang said:
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","")
Click to expand...
 
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","")
 
Back
Top