Forum Discussion

Burns-Mills's avatar
Burns-Mills
Copper Contributor
Jul 05, 2023

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 do i write. 

 

Thanks in advance. 

Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Jul 06, 2023
    Put few sample data as text table then show your desired output.
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jul 06, 2023
    =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".

Resources