I think you have WC and WD reversed in your formula, but copied the formula that I had in my spreadsheet, and converted it to a single formula instead of the multiple cell one. Put this in I7 and then copied it to I8-I18, and it does get the results you expect.
=DATE($B$1,$A7,1)+$B$2-WEEKDAY(DATE($B$1,$A7,1))+($B$2WEEKDAY(DATE($B$1,$A7,1)))*7+7*($B$3-1) $b$1 is the year $a7is the month $b$2 is the weekday (3 being tuesday) $b$3 is the week of month (1 to 4, some months could have 5th for some days) Don't know what WO is, and didn't look at the other stuff. Don't know if you got the email I sent with the speadsheet, or if it got stripped. On 12 Oct 2017 at 10:03, Michael Tiernan wrote: From:Michael [email protected] Subject:Re: [libreoffice-users] Re: Calculating the Nth weekday of a month. To:[email protected] Date sent:Thu, 12 Oct 2017 10:03:09 -0400 On 10/11/17 10:17 PM, Mike Adams wrote: (*snip*) First off, thanks to everyone who did respond! It has been very educational seeing different approaches to this same problem. Mr Thurgood's reference to that online book is helpful to say the least. Thanks! The approach Mr Faye offers gives me some insight into things I never tried. (New toys!) The method Mr Adams offered seems to fit my needs the best (for this purpose) and I've tried it but find that somethings not quite right. Here's a link to a screen shot of the calculations: https://www.dropbox.com/s/b4x50sv2e3ycyxa/mytest-spreadsheet.jpg?dl=0 And this is the spreadsheet I built it from: https://www.dropbox.com/s/mt84id1mg1qkh8h/mytest-spreadsheet.ods?dl=0 In short, I expected for 2017 that the first Tuesday (#3) of Jan should be 1/3/2017 but I get Sunday Jan/1/2017 I'm trying to suss it out but I thought I'd provide that response back. Again, thanks everyone! -- MCTMichael C Tiernan.http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they please, and men and dogs should relax and get used to the idea. -Robert A. Heinlein -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
