IF formula to mark box with an x if after a certain date

[Ashlie63]

I'm having a hard time figuring this one out. I have a date in cell A. If today is greater that 6 months from the date in cell a, how would I forumlate cell b to have an x? I want my spreadsheet to look like this:

Date 6 months 12 months
2/12/16
8/5/15 x
1/8/15 x x
12/1/15
7/14/15 x

I just can't figure out how to get those x's to populate for me automatically. I think it would be an IF formula. Am I wrong?

Thank you so much for the help.

 

[benpauley]

Give this a try:

=IF(TODAY()>EDATE(A2,6),"x","")

This assumes the date to test is in cell A2.