Date Formula help

Copper Contributor

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. 

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

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


With a date in D2:


=TEXT(D2-14, "mmmm")