Excel Help with dates

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","")
 
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","")
 
Joined
Jul 9, 2019
Messages
3
Reaction score
1
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","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top