Hi All,
I am trying to populate the status of a contract . based on its expiry date.
For example :- in cell N with the heading Contract Expiry Date , now i would like to build a formula which can provide me the following result
It should alert me 30 days in advance from the date of expiration of contract with a text saying"renew the contract"
It should alert me 60 days in advance from the date of expiration of contract with text saying "expiring soon"
It should tell me if the contract is under contract of expired
It should return the blank cell as blank
Thank you for your help