The determining factor is the Lease Document itself. The document I'm
creating is an abstract of the lease. What I want to be able to do is input
a lease start date, then the # of months or partial months until the next
incremental increase to arrive at an end date for that rate. I don't quite
understand why the formula I'm using isn't working in just this one
situation. I can input a start date of the 1st of any month and use a
decimal (partial month) as the term and the end date will calculate
correctly. The only scenario where this does not work is when I combine a
partial month term with a start date of other than the first.

I wouldn't nit-pick this, but it is a standardized form with all the
formulas protected to keep people in the field from changing the format.

Do you know of any way to do the following calculation which would cover all
scenarios?:

Start Date (MM/DD/YY) + Term (# mos./partial mos.) = End
Date (MM/DD/YY)

"Duke Carey" wrote:

Any such formula would have to rely on one item of information that you don't
mention - how do you determine whether to use the anniversary date or the end
of a month? Excel doesn't have a telepath feature, so you'll have to figure
out some way to store an indicator.

If the indicator is "EOM" (for End Of Month), then use the EOMonth()
function, otherwise use the EDATE() function

=IF(indicator cell="EOM",eomonth(startdate,#months),edate(startd ate,#months))

"OCD Cindy" wrote:

Thanks again for the help. That works in the scenario where I want to use a
partial term to arrive at an end date of the end of the first month, but
unfortunately that is not always the case. Sometimes a term can begin on
8/23/06 and increase every year on the anniversary date (instead of the 1st).
Is there something else I could try that would work in both scenarios?