In cell C11, 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 excel DATE function. Add 1 to the month result. Copy the function to the range C13:C34.
Solved by O. J. in 29 mins