You mean as in - create a date that is the first Monday of last month? On 9/30/07, Lisa Hetherington <[EMAIL PROTECTED]> wrote: > Perfect Andrew!! > Is there a way to modify the formula to return only weekdays (Mon-Fri) > > ...Lisa > PS I usually see bottom posting here, I just continued top posting to > not confuse things. > > > Andrew Jensen wrote: > > 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] > > > > --------------------------------------------------------------------- > 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]
