Forum Discussion
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...
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
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)
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)
