Excel formula to evaluate two dates to see if either of the range contains a specific month and then list the month name

[klitton7]

In my example, I'm reviewing two sets of dates to determine if the date range would include the month in A1. If yes, the month name would appear in column C next to the dates. If "NO," the field would be blank.

Thank you!

 

[Joe4]

Place this formula in cell C3 and copy down for all rows:

=IF(AND(B3>=$A$1,A3<=EOMONTH($A$1,0)),UPPER(TEXT($A$1,"MMMM")),"")

and here's the proof!

 

[klitton7]

Perfect! Thank you very much!

 

[Joe4]

You are welcome. Glad I was able to help!