Date Formula help

[Burns-Mills]

I want to write a formula to grab the dates from my table and if it is and lower than the 14/07/2023 to say June in the next column over and if it is greater than the 15/07/2023 to say July.

What do i write. 

Thanks in advance. 

[#2]

Put few sample data as text table then show your desired output.

[#3]

=IF(A2<=DATE(2023,7,14),"June","July")

The formula compares the date in cell A2 with the date 14/07/2023. If the date is equal to or earlier than 14/07/2023, it will display "June". Otherwise, it will display "July".

[#4]

@Burns-Mills 

With a date in D2:

=TEXT(D2-14, "mmmm")