How do I set up my amortization based on date paid?

[teripatterson]

I use the Excel Loan Calculator with Extra Payment template often. It shows
the actual principal and interest per payment. How do I formulate the
principal and interest based on the date the payment was made?