calculate total payment based on start and end date

[Dumboy]

Hello there I have a nice task.<br><br>I need to calculate a total per year payments for a 5 year period given a start and ending date and a monthly payment.<br><br>Keep in mind that some payments started on 1999 and some will in 2000, some in 2001..etc.. (note: the start date will always be the 1st of the month and the end date the last of the month)<br><br>Is there a way to write a formula that will calculate the total per year monthly payments based on start and end date?<br><br>example:<br>if start date = 06/01/2000 and<br>&nbsp;&nbsp;&nbsp;end date = 06/01/2001 and<br>Monthly payment = $100.00<br><br>I need to get:<br><br>2000 total monthly payments = $600 and<br>2001 total monthly payments = $600<br><br>Any help is greatly appreciated.<br><br>I will also post this on the MS Office forum<br><br>Thanks again.... <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

 

[Dumboy]

This works for the first part (start date)<br><br>I used the formula:<br><br>=(MONTH(&quot;12/31/1998&quot;-E4))*G4<br><br>Where Month corresponds to the column for 1998 and E4 corresponds to the start date and G4 is the monthly payment.<br><br>now... the second part what should I include in the formula to tell access when to stop<br><br>Note that my current formula would not work if the end date where september 1998.<br><br>The 12/31/1998 has to be replaced... but with what....?<br><br>Eliiiiiizaaaaaabeeeeethhhhhhh...........!<br>DooooooooooouuuuuuuuughP...........! <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!