In cell C11 of Excel, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions within the DATE function. Add 1 to the month result. Copy the function to the range C13:C34.

Answer rating: 100% (QA)

Formula used in cell C11 is B7 It stores the start... View the full answer