Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

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 Tiernanmichael.tiernan@gmail.com
Subject:Re: [libreoffice-users] Re: Calculating the Nth 
weekday of a month.
To:users@global.libreoffice.org
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: users+unsubscribe@global.libreoffice.org
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: users+unsubscribe@global.libreoffice.org
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