What IF formula

Occasional Visitor

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 date is in the past. I have tried: =IF(D9<="today","Active","Expired") and other combinations without much success. I appreciate your help. Thanks  Joe

 

Bid DateContract Contractor'sService/ ProductDepartment  AMOUNT Commnents

# in Place? Y/N       
   BEGINNING Date ENDING Date     
111/27/2021Monday, February 7, 20222/6/2025Drain Cleaning SrvsYESMaintenance $                 150,000.00Active
211/9/2021Tuesday, November 9, 202111/8/2024Tree Trimming & RemovalYESMaintenance $                 150,000.00Active
3 Monday, March 23, 20204/30/2021Trauma Center SrvcsYES Hourly RateActive
4        
2 Replies

@PJoseph22 

Perhaps you may share the same as Excel file sample to check if you have real dates, not texts which looks as the date. and where is column D, etc.

@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 ("<=").