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