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")
=IF(TODAY()>DATE(2021;7;31);"Yes";"")
Hope I was able to help you with this info.