Forum Discussion
What IF formula
Any help with the table below. In the last column to the Right I have been trying to label a particular contract as "active" if the ending date is later in the future and "expired " if the ending ...
PJoseph22 wrote: ``"active" if the ending date is later in the future and "expired " if the ending date is in the past``
Among other mistakes, your IF expression has that reversed. Try:
=IF(D9<TODAY(), "expired", "active")
Note the use of less than ("<") instead of less than or equal to ("<=").