I am trying to create a formula that will change a column to say Active or Inactive based on the numbers of days before an item expires.
For example: I have contracts that expire over the next four years. When one of the contracts gets within 6 months of expiring I need a column to change to Active or Inactive. All of the Actives will be within 6 months of expiring Inactives will be anything valid for more then 6 months.
I tried to use this formula I found in the forums and changed my expiration date column to Purchase Date just so the columns would match and it keeps telling me that it is an invalid formula.