On Fri, 2006-11-08 at 23:07 +0200, Andreas Saeger wrote: > William Case wrote: > > Hi;
> Not exactly, but I could copy and paste. > First day of week for some month: > =DATE(myYear;MyMonth;1)+MOD(myDoW-WEEKDAY(DATE(myYear;MyMonth;1));7) > where myYear and myMonth specify the month in question and myDoW is a > day-of-week-number as returned by WEEKDAY(Date). Sun=1,...Sat=7. > > Same with last day of week for some month: > =DATE(myYear;MyMonth+1;0)-MOD(WEEKDAY(DATE(myYear;MyMonth+1;0))-myDoW;7) > Test with some named style having a date-format like YYYY-MM-DD NN > (2006-06-02 Fr) > > --------------------------------------------------------------------- The 0 (0.000000) date value still gives me '30/12/1899'. So there is no problem there, but thanks for the tip of using zero as a start date rather than 30/12/1899. Cleans things up. I appreciate your sharing your formulae, but WEEKS() seems neater and cleaner and has the advantage of being built in, if only I could be certain that the Type in WEEKS(Start Date; End Date; Type) meant what I think it means. I am going to apply your formulae -- after dinner -- and see if I end up at the same place. Thanks again. -- Regards Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
