IF Formula Help in Date Range

[Kelley_Martin]

It’s been too long since I’ve done complex formulas… I’m trying to identify active contracts. On each contract record I have a start date and an end date. I also have a column where the formula sits, looking for active contracts. This looks like it should work to me. Any ideas?

IF( ( (TODAY > StartDate) AND ( TODAY < EndDate) ),“Yes”,“No”) )

Thanks in advance. :slightly_smiling_face:

[Kelley_Martin]

I’ve now played around with it a bit more and added a column to determine “today” separately and fixed my “and” statement. Still not working.

IF( (AND (Today >= StartDate), (Today <= EndDate)), “Yes”, “No”)