Return value if one condition is met

Veronica J

Good Morning,

I am trying this formula within my sheet in a brand new column:

=IF([Planned Start Date]@row - 21 <= TODAY(), [Estimated Hours Number]@row, "")

For this column, if someone put a date that falls between today and three weeks from today, to return the job site hours that is found in the column Estimated Hours Number. IF the date doesn't fall within the three weeks or if the cell is blank, return a blank. 

This formula keeps returning a value. The IF condition isn't met, it still returns the value found in column Estimated Hours Number. I don't understand how it is doing this when the condition is false. I have tried using "" and using 0. Do I need to restructure this formula?

Thank you,

Veronica

Veronica J

Using this:

=IF(AND([Planned Start Date]@row - 21 < TODAY(), [Planned Start Date]@row <> 0), [Estimated Hours Number]@row, "")

Formula helped to achieve a blank return because the planned start date was blank however, if the date falls into the three week period or has a date but it isn't in the three weeks, it returns error message "INVALID OPERATIONS"