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