This week I had a need to determine the payoff dates for some mortgages and along the way I found the “EDATE” function in Excel. You give the function the start date and the number of months and it returns the payoff date.
This week I had a need to determine the payoff dates for some mortgages and along the way I found the “EDATE” function in Excel. You give the function the start date and the number of months and it returns the payoff date.