Forum Discussion
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...
=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".
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".