What IF formula

[PJoseph22]

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
1	11/27/2021	Monday, February 7, 2022	2/6/2025	Drain Cleaning Srvs	YES	Maintenance	$                 150,000.00	Active
2	11/9/2021	Tuesday, November 9, 2021	11/8/2024	Tree Trimming & Removal	YES	Maintenance	$                 150,000.00	Active
3		Monday, March 23, 2020	4/30/2021	Trauma Center Srvcs	YES		Hourly Rate	Active
4

[#2]

@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.

[#3]

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