You'll probably want to use the EDATE formula somehow (see XL help file)
Note that you'll need to have the Analysis ToolPak Add-in turned on for this
function to work.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trish" wrote:

I am using a Amortization Schedule template from Microsoft Office online. I
am trying to change the Per Period from Monthly - Semi-Monthly etc... to days
per year. My current loan is based on a 360 day year and not a 365 which
changes the interest payment monthly. Can anyone help me.