Struggling with If statement

Kelly Ospina

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

 

 

 

rjudenberg

try

=IF(ISDATE([Estimated Close Date]1), IF([Estimated Close Date]1 >= DATE(2018, 6, 1), 1, 0), 0)

Kelly Ospina

That did it, thank you!

Could you tell me, is it possible to modify this formula to check the box if the date in Estimated Close Date is less than one date, greater than another?

rjudenberg

=IF(ISDATE([Estimated Close Date]1), IF(AND( [Estimated Close Date]1 >= DATE(2018, 6, 1), [Estimated Close Date]1 < DATE(2019, 5, 31)),1, 0), 0)

Kelly Ospina

THANK YOU! You have no idea how much you have just simplified something I've been grappling with for weeks.