Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating Due Dates Based on Payments
Hello,
I need to create a forumla that will automatically calculate the next due date based on a loan start and finish, first due, payment amount due, dates paid and amounts paid. I know there is a way to do it, but I am completely at a loss. Any help would be appricated. Please respond to as well. |
#2
|
|||
|
|||
The EDATE function will allow you to add a specific number of months to a
starting date. Maybe that's what you have in mind. It's a function in the Analysis Tool Pack add-in. Help tells you how to install it. Otherwise, to add, say, 3 months to the date in A1, the formula is =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) On Wed, 5 Jan 2005 16:21:05 -0800, "Eric Hanson" <Eric wrote: Hello, I need to create a forumla that will automatically calculate the next due date based on a loan start and finish, first due, payment amount due, dates paid and amounts paid. I know there is a way to do it, but I am completely at a loss. Any help would be appricated. Please respond to as well. |
#3
|
|||
|
|||
Isn't the due date independent of the payment amounts? Isn't it strictly a
function of the payment period. For example, a monthly loan with a last payment date of Dec 15th will have a next payment date of Jan 15th. If the last payment date is in A1, you can calculate due date as =date(year(a1),month(a1)+1,day(a1)) Regarding duplicate responses by e-mail, most posters don't do this because: 1. They don't want to risk more spam by disclosing their e-mail address; 2. Responses back to the newsgroup are available for all to see, rather than just one person; 2. They assume people who ask for free advice are willing to do a little bit of work to get it. -- Regards, Fred Please reply to newsgroup, not e-mail "Eric Hanson" <Eric wrote in message ... Hello, I need to create a forumla that will automatically calculate the next due date based on a loan start and finish, first due, payment amount due, dates paid and amounts paid. I know there is a way to do it, but I am completely at a loss. Any help would be appricated. Please respond to as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating service dates | Excel Worksheet Functions | |||
How can i filter dates based on day of month | Excel Worksheet Functions | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions | |||
I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Totals based on dates | Excel Worksheet Functions |