Forum Discussion

Dazumi30's avatar
Dazumi30
Copper Contributor
Aug 05, 2020

Excel formula to populate a cell with Yes/No depending on dates on other cells.

Dear Team, Pleas I need assistance in writing an excel formula to accomplish the following scenario. For an equipment sign in/out sheet, I want a cell to be populated with either a "Yes " or "No...
Formulas and Functions
Dazumi30's avatar
Dazumi30
Copper Contributor
Aug 05, 2020

HansVogelaar 

 

Thanks for your prompt response. The formula works very well.

ROB_N375's avatar
ROB_N375
Copper Contributor
Jul 20, 2023

CAN ANYONE TELL ME HOW I CAN GET A YES OR NO ANSWER ON WHETHER A DATE IS GREATER THAN 28 DAYS OR LESS THAN 28 DAYS I.E. BASED ON THE DATES IN ONE COLUMN ANOTHER COLUMN WOULD HAVE A FORMULA TO DISPLAY YES OR NO DEPENDING IF THAT DATE WAS 28 DAYS AGO OR LESS. HOPE THIS MAKES SENSE

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 20, 2023

    ROB_N375 

    Let's say you have dates in D2 and down.

    In E2:

    =IF(D2<=TODAY()-28, "Yes", "No")

    Fill down.

     

    (Please turn off Caps Lock. Using ALL CAPS is the internet equivalent of shouting loudly)

    • ROB_N375's avatar
      ROB_N375
      Copper Contributor
      Jul 20, 2023

      HansVogelaar I KNOW IT IS!! by the time i realised i'd written my question and it was too late lol!

       

      Thanks for your reply, very helpful. How would i stop it picking putting a "yes" or "no" if i extend the formula down in column E where there are not yet any dates in column D (using your example below)

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jul 20, 2023

        ROB_N375

         

        =IF(D2="", "", IF(D2<=TODAY()-28, "Yes", "No"))

Resources