IF/AND Formula with Dates

Hi all,

I am trying to create a formula that will apply an X to a cell if the selected Date is between two other Dates (ie. Check In and Check Out dates).

Currently I have a formula similar to what you would use in Excel:

=IF(AND([TUESDAY 4/20]17 >= [CHECK-IN]@row, [TUESDAY 4/20]17 <= [CHECK-OUT]@row), "X")

Check In and Check Out columns are Date Format.

"Tuesday 4/20" Column is just a Text/Number Column and is where I would like to have an "X" appear.

Thanks in advance for any insight!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!