Hi,
I am trying to have 3 options: 1) Renewal Pending, 2) Valid, 3) Expired
Renewal pending should be considered only when the "Agreement Due Date" is under 30 days of today's date
Expired should be considered if the "Agreement Due Date" has passed
Else it should consider valid
I have tried different formulas but it is not working.
Have attached the sheet with my calculations. Please help.
Bookmarks