Check if today is in between the date in two cells

Bethany Garcia

I am trying to get a formula to return a specific value if today is in between the date of two cells in a sheet, but I'm getting an #UNPARSEABLE error. This is the formula I am using:

=IF(AND(TODAY() > [Temp Move 1 Move In Date]@row, TODAY() <= [Temp Move 1 Move Out Date]@row), "Temp Move 1", "Not Temp Move 1"))

The column names of the dates I am comparing are Temp Move 1 Move In Date and Temp Move 1 Move Out Date.

John Jonassen

I'm not sure why it won't work the way you have it written, but try this...essentially the same thing, just flipping things around a bit:

=IF(AND([Temp Move 1 Move In Date]@row < TODAY(), [Temp Move 1 Move Out Date]@row >= TODAY()), "Temp Move 1", "Not Temp Move 1")