Identify Renew License

[sunil-kumar5]

Hi All,

I have a installation date and due date column and on the basis of on these two columns I want to identify the status of licensed as (Active, Expired and Renew). Please find the below dummy data. The difference of Due date is 365 Days, I want to give some idea about the renew as Apr-19 is the installation date so Apr-2020 would be the due date however that customer renew the license in that month and due date update to Apr-21 that is how we can catch the renew condition. For Expired any due date which is less than today() is expired and rest are actives like all fall under today-365 and  greater than today. 

Conditions
Installation_Date	Due_Date
Apr-19	Apr-21
Dec-19	Dec-20
Mar-20	Mar-21
May-19	May-20
Jun-19	Jun-21

Requirement:

Installation_Date	Due_Date	Result Should be:
Apr-19	Apr-21	Renew
Dec-19	Dec-20	Active
Mar-20	Mar-21	Active
May-19	May-20	Expired
Jun-19	Jun-21	Renew

Thanks in advance

Please advise

Sunil

[sunil-kumar5]

Can someone please look into it?

[GaryGiles · Accepted solution]

Not sure of all of your requirements, but this works for your small sample set.

=If(Due_Date<Today(),'Expired',
If(AddMonths(Installation_Date,12)<Due_Date,'Renew','Active'))