Could someone help me create a formula for the following scenario? We run an accreditation system, and have a policy that went into effect on January 1, 2018 saying that programs have five years from the date of their application to submit their report to us or their eligibility will expire, but programs that applied before that policy went into effect were grandfathered in and have five years from January 1, 2018.
If it’s helpful, my application date field is in MM/DD/YYYY format, and I’d like the expiration date to generate in the same format.
If (application date field) is before 01/01/2018, (expiration date field) is 12/31/2022. If (application date field) is after 01/01/2018, (expiration date field) is 5 years after (application date field). If (application date field) is empty, (expiration date field) is blank