Well, three options - I'll try to give you a solution...which will be a while as I have other commitments right now. And I am not much of a Calc guy, more Base...so I would be slow anyway..*smile*...
Two - someone else reading this will do so. Three - you could slip over to one of the forums and ask, the OOoForum has some really good calc guys that would do this, or the 8DaysAWeek forum has a good calc guy also. Sorry. I have to scoot for now - if I don't see a response later I'll give it a try, OK..but I really would recommend www.OOoForum.org or www.8daysaweek.org either one will get you someone that can whip this right out. Or you could try it yourself...lookup help for IF and WEEKDAY together it should be fairly straight forard IF( WEEKDAY(<YourNewDate>, 3) <> 6 AND WEEKDAY( ....) <> 7, <YourNewDate>, IF (WEEKDAY(<YourNewDate>, 3) = 6, <YourNewDate> + 1, <YourNewDate> + 2 ) or something like that. On 9/30/07, Lisa Hetherington <[EMAIL PROTECTED]> wrote: > Not exactly, > If my formula returns a date that falls on a Sat or Sun, I would like it > to advance to the Mon after the weekend (when I would be at work). > > ...Lisa > > Andrew Jensen wrote: > > 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]
