Forum Discussion

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

HansVogelaar

MVP

Aug 05, 2020

Dazumi30

In E4:

=IF(AND(INDEX(C4:C1000,COUNT(B4:B1000))<>"",INDEX(D4:D1000,COUNT(B4:B1000))=""),"Yes","No")

If you expect to fill below row 1000, adjust the formula accordingly.

Dazumi30

Copper Contributor

Aug 05, 2020

HansVogelaar

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

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