Date calculation

[alextveit]

First off, I apologize if it has been answered, but I couldnt find this specifically.

I need to be able to calculate a loan end date from a start date and a term:

Start Date: 04/01/04

Term: 36 months

Calculated end date: 03/31/07

The problem that I am having, is of course that depending on the years that are entered, sometimes I will get a day before, or a day after...i.e 03/30/07 or 04/01/07. Is there a way around this, so I can actually get the right date all the time?

[Raybaudi]

Date ( Month ( start date ) + Term ; Day ( start date ) ; Year ( start date ) )

[alextveit]

thank you! When I added -1 to that....it works perfectly:D

[Raybaudi]

If you want always an End Date to the end of the month:

Date ( Month ( start date ) + Term ; 0 ; Year ( start date ) )