Is this the right formulas for Expiration Dates?

PeterM

=IF([Land Owner/Tenant]@row = "Owner", IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF(OR([Buyout Closing Date]@row <> "", [Vacancy Inspection Date]@row <> ""), MIN(IF([Buyout Closing Date]@row = "", 99999999999999, [Buyout Closing Date]@row), IF([Vacancy Inspection Date]@row = "", 9999999999999, [Vacancy Inspection Date]@row + 365)), IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF([Vacancy Inspection Date]@row = "", "", [Vacancy Inspection Date]@row + 365)))))

Thank you!

Paul Newcome

You are going to need to provide more context. What is the expectation for how the formula is supposed to work , and are you able to provide a screenshot for reference?