Can a formula be written to have a date automatically update dependent on information in two other fields?

I assume 'Term' then is the original Basis of the contract? 

Something like this might help get you started ( this likely won't be your true end result ): 

If(
     [Renewal Exposure]="Auto-Renewal" and AdjustMonth([Effective Date],[Term])<Today(), AdjustMonth([Effective Date],[Term]) + [Renewal (Days)], AdjustMonth([Effective Date],[Term]))

Basically if it auto-renews, and you've passed what the 'original' expiration date, then add 12 months (your term from above) to the effective date, then add another 30 days. 

Otherwise just do the Effective Date + 12 months

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base