Forum Discussion
Solved
How to make "Yes" appear in a cell if date in another cell is 5 months out from todays date
Hello, I would like some help getting a formula that would help automatically put a "Yes" if the date in column I is greater than 5 months from todays date. Can anyone help with this? I have bee...
Aha - you meant dates in the past; I thought it was about dates in the future.
=IF(I2<EDATE(TODAY(),-5),"Yes","No")
Thanks, this did not work, but I feel like its the right idea! I love NikolinoDE s response above too, but I am looking for this to be continuous without me having to input the date 5 months prior every time. This will be an ongoing spreadsheet.
HansVogelaar The cells are showing up blank with what you have posted. Is this because of the last "" ?. I would to also expand on this formula that if the date is not more than 5 months ago, "No" would show up. I hope I make sense.
HansVogelaar The cells are showing up blank with what you have posted. Is this because of the last "" ?. I would to also expand on this formula that if the date is not more than 5 months ago, "No" would show up. I hope I make sense.
I dont think it's working. The text shows up with whatever I place in the last "" of the formula. See attached pic. The top one should say No, but the bottom one should say Yes (since this date is greater than 5 months ago).