1. In the range E6:E14, Darius needs to enter a formula to calculate the expiration dates for the service agreements, which expire after one year. He wants to use a defined name in the formula as he did on the Tampa worksheet. Calculate the expiration dates as follows:
   1. Examine the formula in cell G6, which uses a defined name to calculate the sale price.
   2. Assign the same defined name (Contract_Orlando) to the range C6:C14, which resolves the errors in column G.
   3. In cell E6, enter a formula without using a function to determine the expiration date by adding 365 to the defined name Contract_Orlando.
   4. Fill the range E7:E14 with the formula in cell E6.

A Cancel B D E F G H I J K L M 1 NP C SmartEnergy Services Service Agreements - Quarter 1 2 Discount offered for 3 purchases before: 4 Sale price 2/15/21 rate: 87.15% Years in Business Company Contact State Invoice Number 5001 5531 5365 5458 5514 5698 5744 5834 5966 Contract Date 1/5/21 1/18/21 2/1/21 2/16/21 2/28/21 3/3/21 3/14/21 3/19/21 3/27/21 Equipment Expiration Code Date 103 104 101 101 102 5 Customer Name 6 Mario Galdez 7 Kirk Bateman 8 Monique Dwyer 9 Amy Hamann 10 Eric Knapstein 11 Britt Fillner 12 Jane Chin 13 Vernon Elsberry 14 Sameer Ch 15 Totals 16 17 18 Standard Price Sale Price $395.00 #NAME? $819.00 #NAME? $588.00 #NAME? $588.00 #NAME? $735.00 #NAME? $819.00 #NAME? $588.00 #NAME? $395.00 #NAME? $395.00 #NAME? $5,322.00 #NAME? 104 101 103 103 19 20 21 A Cancel B D E F G H I J K L M 1 NP C SmartEnergy Services Service Agreements - Quarter 1 2 Discount offered for 3 purchases before: 4 Sale price 2/15/21 rate: 87.15% Years in Business Company Contact State Invoice Number 5001 5531 5365 5458 5514 5698 5744 5834 5966 Contract Date 1/5/21 1/18/21 2/1/21 2/16/21 2/28/21 3/3/21 3/14/21 3/19/21 3/27/21 Equipment Expiration Code Date 103 104 101 101 102 5 Customer Name 6 Mario Galdez 7 Kirk Bateman 8 Monique Dwyer 9 Amy Hamann 10 Eric Knapstein 11 Britt Fillner 12 Jane Chin 13 Vernon Elsberry 14 Sameer Ch 15 Totals 16 17 18 Standard Price Sale Price $395.00 #NAME? $819.00 #NAME? $588.00 #NAME? $588.00 #NAME? $735.00 #NAME? $819.00 #NAME? $588.00 #NAME? $395.00 #NAME? $395.00 #NAME? $5,322.00 #NAME? 104 101 103 103 19 20 21