Date If 6 months before Date or 6 Months after

[Diggsy]

Hello
I have a sales transactions sheet and I would like to add a column that would look at the sales date and compare it to a date in a referenced cell. If the Sales date is equal or 6 months greater. I would like column to state AFTER. if 6 months before referenced date , I would like the column to show Before. Any other date column should be Null. Any suggestions would be greatly appreciated.

Thanks

Chris

 

[Scott Huish]

Excel 2010
	A	B
1	1/1/2018
2
3
4	2/13/2018
5	7/1/2017	BEFORE
Sheet1

Cell Formulas
Range	Formula
B4	=IF(A4<=EDATE($A$1,-6),"BEFORE",IF(A4>=EDATE($A$1,6),"AFTER",""))
B5	=IF(A5<=EDATE($A$1,-6),"BEFORE",IF(A5>=EDATE($A$1,6),"AFTER",""))