I need help with the formula to find the normal payoff date based on the scheduled number of payments. The normal payoff date should equal the date that corresponds with the payment number that is in the scheduled number of payments in the loan summary table. The scheduled number of payments can vary with different loan terms. Need help in with the formula in excel that will automatically change the normal payoff date based on the scheduled number of payments. Below are the loan parameters and loan summary information and part of the amortization table.

Loan Parameters					Loan Summary Information
$ 400,000	Principal				Monthly Payment (P&I Only)		$2,923.71
6.25%	Annual Interest Rate				Scheduled Number of Payments		240
3/1/2015	Date of First Payment				Normal Payoff Date
20	Term of Loan (Years)				Actual Number of Payments		240
12	Number of Payments Per Year				Actual Payoff Date		2/1/2035
$0.00	Extra Payment Every Period				Total of Extra Payments		$0.00
					Total of All Interest Payments		$ 301,691.07
Payment Number	Date	Beginning Balance	Regular Payment	Interest	Principal	Extra Payment	Ending Balance
1	3/1/2015	$ 400,000	2923.71281	$ 2,083.33	$ 840.38	$0.00	$ 399,159.62
2	4/1/2015	$ 399,159.62	2923.71281	$ 2,078.96	$ 844.76	$0.00	$ 398,314.86
3	5/1/2015	$ 398,314.86	2923.71281	$ 2,074.56	$ 849.16	$0.00	$ 397,465.71
4	6/1/2015	$ 397,465.71	2923.71281	$ 2,070.13	$ 853.58	$0.00	$ 396,612.13
5	7/1/2015	$ 396,612.13	2923.71281	$ 2,065.69	$ 858.02	$0.00	$ 395,754.10