Hi Lisa Qutoe: "Since months and years do not have regular count of days you need DATE as a helper: Same day, next month: =DATE(YEAR(A1);MONTH(A1)+1;DAY(A1)) Contrary to the lousy documentation, DATE can calculate dates by positive, negative and zero arguments. It knows about leap years and count of days. Last day of this month is zeroth day of next month: =DATE(YEAR(TODAY());MONTH(TODAY())+1;0) "
The actual post can be found at http://www.oooforum.org/forum/viewtopic.phtml?p=235456#235456 Drew On 9/30/07, 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.... > > > ...Lisa > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
