Date Formula help

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...