IF Formula Help in Date Range


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. :slight_smile:


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