I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date.
Here is what I have, that is not working:
=IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1)))
Estimated Close Date is a date column. The formula I am trying to build is in a check-box column.
Basically, what I am trying to do is ascertain if the Estimated Close Date in the date column falls within our fiscal year or not. I have one check box column to check if date is greater than fiscal year start, then another if less than fiscal year end, and a third column to check if both previous boxes are checked. Probably not the best way to do this, but I really struggle with formulas of this nature.
Any and all help is appreciated.
Link to published view of sheet: https://publish.smartsheet.com/c057994f5a78412db46de247aa5c041e