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 been working on =IFS, but haven't had success. Anything helps, thanks!
Aha - you meant dates in the past; I thought it was about dates in the future.
=IF(I2<EDATE(TODAY(),-5),"Yes","No")
12 Replies
- 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.
=IF(TODAY()>DATE(2021;7;31);"Yes";"")
Hope I was able to help you with this info.
