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]

Do you just mean this or am I missing something:-
In A2 put

=IF(MONTH($A2)=5,"YES","NO")

 

[My Aswer Is This]

Try this:

Sub Check_Dates()
'Modified 5/11/2022  4:35:33 AM  EDT
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
Dim mm As Long
mm = InputBox("Enter Month Number To Check For", "Enter Month Number", "5")
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
Dim ans As Long
For i = 2 To Lastrow
ans = Month(Cells(i, 1).Value)
If ans = mm Then
Cells(i, 2).Value = "YES"
Else
Cells(i, 2).Value = "No"
End If
Next
Application.ScreenUpdating = True
End Sub

 

[Manojlo]

Do you just mean this or am I missing something:-
In A2 put

=IF(MONTH($A2)=5,"YES","NO")

Yes, I mean like that.
Thank you

 

[Manojlo]

Do you just mean this or am I missing something:-
In A2 put

=IF(MONTH($A2)=5,"YES","NO")

I need update, I need comments on date (month and year) before May 2022?

Do you know how to add a year also?
In case that I have some dates before 2022?

 

[Alex Blakenburg]

Try this:

=IF(AND(YEAR($A2)=2022,MONTH($A2)=5),"YES","NO")

 

[bebo021999]

Why "May"? Do you wish it to be "Jun" for next month?

=IF(EOMONTH(A2,0)=EOMONTH(TODAY(),0),"YES","NO")

 

[Manojlo]

Why "May"? Do you wish it to be "Jun" for next month?

=IF(EOMONTH(A2,0)=EOMONTH(TODAY(),0),"YES","NO")

Maybe I did not well explain, sorry.
I need formula in column B (depend on date in column A) to receive return value depend on date. Condition are that all dates (before and current month and year also in cell C1 & D1) to have value YES, and all other month and year after current month to have value NO.

 

[Alex Blakenburg]

You can probably figure out the last part yourself from my previous post but..

=IF(AND(YEAR($A2)=$D$1,MONTH($A2)=$C$1),"YES","NO")

 

[Manojlo]

You can probably figure out the last part yourself from my previous post but..

=IF(AND(YEAR($A2)=$D$1,MONTH($A2)=$C$1),"YES","NO")

Tnx, with this formula I don't receive return "YES" on year before 2022?