On 01/10/2007, Lisa Hetherington <[EMAIL PROTECTED]> wrote: > > Adrian Try wrote: > > Hi Lisa > > > >> I would like one cell to return an addition or subtraction of months > >> or years from the date in another call. (whatever the need is) > > > > Have a look at the months and years functions. > > > > This is from the online help: > > > > MONTHS > > Calculates the difference in months between two dates. > > Syntax > > MONTHS(Start date, End date, Type) > > Start date: First date > > End date: Second date > > Type: Calculates the type of difference. Possible values include 0 > > (interval) and 1 (in calendar months). > > > > YEARS > > Calculates the difference in years between two dates. > > Syntax > > YEARS(Start date, End date, Type) > > Start date: First date > > End date: Second date > > Type: Calculates the type of difference. Possible values are 0 > > (interval) and 1 (in calendar years). > > > > Hope this helps. > > > > Adrian > > www.tryanotherangle.org > > Thanks Adrian...that is not quite what I wanted to do. > I have the difference and one date. I do not have two dates to > calculate the difference of. I would like to calculate the 2nd date. > > I have a date in A1 (Oct 18, 2007) and I know I can enter > > =A1+2 and that returns a date of Oct 20, 2007 > =A1-36 returns a date of Sept 12, 2007 > That works for days. > > How do I have Calc add or subtract months or years....
To add a month: =EDATE(A1;1) To add 3 months: =EDATE(A1;3) To add a year: =EDATE(A1;12) To add 3 years: =EDATE(A1;36) In general, the second argument is the number of months to add; negative numbers work too :-) -- Harold Fuchs London, England Please reply *only* to [email protected]
