Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))
Can someone please look into it?
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'))