If/Then Statement - Date Greater Than or Less Than 30 Days

[juleskaynel]

I have a column of Dates (example below). In a separate field, I need to identify which dates are greater than or less than 30 days. I need help writing this statement.

Created

06/20/2017 10:21 AM

06/01/2017 07:36 AM

06/01/2017 06:36 AM

06/08/2017 10:20 AM

<colgroup><col></colgroup><tbody>
</tbody>

Thanks in advance for the help!
Julie

 

[MrKowz]

Something like this?

Excel 2013/2016
	A	B
1	Date List	Result
2	6/20/2017 10:21	Over or equal to 30 days
3	6/1/2017 7:36	Over or equal to 30 days
4	6/1/2017 6:36	Over or equal to 30 days
5	6/8/2017 10:20	Over or equal to 30 days
6	7/24/2017	Less than 30 days
7	7/4/2017	Less than 30 days
Sheet1

Cell Formulas
Range	Formula
B2	=IF(TODAY()-A2>=30,"Over or equal to 30 days","Less than 30 days")