I'm working on a formula to align with our business' invoicing policy. The rules are that, if an order is placed, the first invoice is generated same day.
=IF(OR(I90='2b - LookUp Values-UI'!K185,I90=TODAY()),"PASS","FAIL")
The above is sufficient for that requirement; however, I need to create another formula that will take the original invoice date into account and schedule the 2nd and 3rd invoices for exactly 1 and 2 years later. (e.g. If the initial invoice generates 2/15/2019, they Y2 Invoice will automatically generate 2/15/2020, and the Y3 will generate 2/15/2021)
Any help is greatly appreciated.