calculating maturity dates

Assume 12/1/99 is in cell a1

in B1 =Date(Year(A1),Month(A1)+36,1)

Returns 12/1/2002

=Date(Year(A1),Month(A1)+35,1)

Returns 11/1/2002

Assume 12/5/99 is in A3

then

=A3+120 returns 4/3/2000

=A3+119 returns 4/2/2000

You will have to be the arbiter of which additive numbers to use to get the

right answer.

Chip Pearson has an extensive page of information on working with Dates and

Times.

http://www.cpearson.com/excel/datetime.htm Dates and Times

http://www.cpearson.com/excel/DateIntervals.htm Date Intervals

http://www.cpearson.com/excel/datedif.htm The undocumented Datedif function

(documented in Excel 2000)

Datedif computes the difference between two dates.

datedif("12/1/1999","11/1/2002","m") returns 35 by the way.

http://www.cpearson.com/excel/DateAdd.htm Adding Months and Years

HTH,

Tom Ogilvy

Quote:

>I need a formula to add months or years to given date to calculate loan

>maturity. For example the loan closes on 12/1/99 and matures 36 months

>later on X date. (The calculated beginning and maturity dates are always

>the first of the month). The answer is 11/1/2002.

> On occasion I also need to figure a loan closes on 12/5/99 and matures 120

>days later on X date. In this case the maturity date is not the first of

>the month but the actual 120th day including 12/5/99. Feb. 29th, whenever

>it occurs, really adds fun to this calculation.

>Help me end the embarrassment of being a 48 year old professional sitting

in

>front of a computer ---counting on his fingers and leafing through a

>calendar.