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")

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")

Bethany Garcia

I think that is working, thank you!