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