Formula Help Date Arrays

[scotty1978]

Hello, any help would be much appreciated. I am trying to create a formula that will reference a start date Column A and end date Column B and create a value (GOOD) on another array for the month-Row 1. The term GOOD will appear on the array for the month in ROW 2 (under the corresponding date in ROW 1) if it's equal to the date or falls between the start and end dates of the array in column A and B. Image below for reference. Thanks again!!!!

 

[Fluff]

How about

=IF((A3<=$C$1:$W$1)*(B3>=$C$1:$W$1),"Good","")

 

[scotty1978]

How about

=IF((A3<=$C$1:$W$1)*(B3>=$C$1:$W$1),"Good","")

This works beautifully! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.