Generating a new Opportunity/Renewal based on Current Account's Contract End Date

Generating a new Opportunity/Renewal based on Current Account's Contract End Date

Hi - 

Is there a way to set it up so we can have the system look up our existing contracts (under Accounts) that have end dates in Q1 2016 (between 1/1/16- 3/31/16).  If any of the existing Accounts have contracts that are set to expire in that time period, it will generate a new Opportunity and pull in the Account Owner, Account Contract Name, and the info below:

Opportunity Info should map to Account Information - see below:

Opportunity Owner = Account Contract Owner
Opportunity Name - Account Name
Renewal ACV = Contract ACV 
Amount = Renewal ACV

Should set due date to 15 days prior to expiration date of contract