How to return a comment depending on the date in the cell?

[Manojlo]

In column "A" I have different dates, and I want to have in column "B" comments "YES" or "NO" depends of dates in cells "A".
For example, all dates in May to return comment "YES" in column "B" and all other dates, after May, to return comment "NO".

 

[Alex Blakenburg]

I think I misunderstood your requirement. If you want everything in and before the nominated month try this:

=IF($A2<=EOMONTH(DATE($D$1,$C$1,1),0),"YES","NO")

 

[Manojlo]

I think I misunderstood your requirement. If you want everything in and before the nominated month try this:

=IF($A2<=EOMONTH(DATE($D$1,$C$1,1),0),"YES","NO")

Thank you, that is I want.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.