Skip to main content

IF Formula Help in Date Range

  • October 21, 2016
  • 1 reply
  • 21 views
K

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:

    This topic has been closed for replies.

    1 reply

    K
    • Kelley_Martin
    • Author
    • New Participant
    • October 21, 2016

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

    Terms & ConditionsAccessibility statement