Forum Discussion

Copper Contributor

Jan 13, 2022

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

excel

Formulas and Functions

HansVogelaar
Jan 13, 2022
JJIPNM

Aha - you meant dates in the past; I thought it was about dates in the future.

=IF(I2<EDATE(TODAY(),-5),"Yes","No")

JJIPNM

Copper Contributor

Jan 13, 2022

HansVogelaar

MVP

Jan 13, 2022

JJIPNM

Aha - you meant dates in the past; I thought it was about dates in the future.

=IF(I2<EDATE(TODAY(),-5),"Yes","No")

JJIPNM
Copper Contributor
Jan 13, 2022
lol, actually you were correct, I just didnt change the <. Im a dork. Thank you again. I appreciate your time!
JJIPNM
Copper Contributor
Jan 13, 2022
Oh yes!! Duh, I didn't even notice that either. It didn't work at first, but I switched the No and Yes around and now it works PERFECTLY. THANK YOU SO MUCH!