Hi friends
I am looking to develop a formula that will return the next renewal date after one and then each subsequent year. I tried a couple of ways but couldn't finalize it.
For e.g. if the start date is 01-May -2019 then the auto-renewal date should return 30-Apr-2020. However, if today is more than 30-Apr-2020 , then the auto-renewal date should return 30-Apr-2021 and this is how it should continue to give next year date based on today's date.
Can you please advise how can I develop a formula for this?
Thanks in advance.
I am looking to develop a formula that will return the next renewal date after one and then each subsequent year. I tried a couple of ways but couldn't finalize it.
For e.g. if the start date is 01-May -2019 then the auto-renewal date should return 30-Apr-2020. However, if today is more than 30-Apr-2020 , then the auto-renewal date should return 30-Apr-2021 and this is how it should continue to give next year date based on today's date.
Can you please advise how can I develop a formula for this?
Thanks in advance.