=Seems to be a lot of work with all the sheets. Year 2017 Month 1 January =CHOOSE(B2,January,February,=March,April,May,June,;July,August,September,October,"November,December) Day 1 Sunday =CHOOSE(B3,Sunday,Monday,ot;Tuesday,Wednesday,Thursday,Fridayuot;,Saturday) Week 1 First =CHOOSE(B4,First,Second,t;Third,Fourth,Fifth) Sunday, January 1, 2017 =DATE(B1,B2,1)+B3-WEEKDAY(DATE(B1,B2,1))+(B3WEEKDAY(DATE(B1,B2,1)))*7+7*(B4-1) Sunday, January 1, 2017 =DATE(B1,B2,1)+B3-WEEKDAY(DATE(B1,B2,1))+((B3WEEKDAY(DATE(B1,B2,1)))+B4-1)*7
Pasted the cells from spreadsheet, but it might loose all formating for list. In rows 2-4, added a simple choose option to show the text version of the Monday, Day, and Week selected. Four input cells in B1-B4, provide data for single formula in C7 and C8. Set the date format to show the Day of Week, Monday, Day, Year</div> Saved CSV version Row 1: Year,2017,, Row 2: Month,1,January,=CHOOSE(B2,January,þbruary,March,;April,May,June;,July,August,September,October,November=,December) Row 3: Day,1,Sunday,=CHOOSE(B3,Sundayuot;,Monday,Tuesday,=Wednesday,Thursday,Friday,Saturday) Row 4: Week,1,First,=CHOOSE(B4,Firstot;,Second,Third,ot;Fourth,Fifth) Row 5: Just blank ,,, Row 6: Just blank ,,, Row 7: C7 has the calculated date, as created. D7 has the actual formula from cell C7 in text format ,,Sunday, January 1, 2017,=DATE(B1,B2,1)+B3-WEEKDAY(DATE(B1,B2,1))+(B3WEEKDAY(DATE(B1,B2,1)))*7+7*(B4-1) Row 8: Same as Row 7, but slight difference in formula. ,,Sunday, January 1, 2017,=DATE(B1,B2,1)+B3-WEEKDAY(DATE(B1,B2,1))+((B3;WEEKDAY(DATE(B1,B2,1)))+B4-1)*7 On 16 Oct 2017 at 5:01, Jan Flikweert wrote: Date sent:60;Mon, 16 Oct 2017 05:01:58 -0700 (MST) From:60;Jan flikweertjanflikwe...@tele2.nl To:;users@global.libreoffice.org Subject:;[libreoffice-users] Re: Calculating the Nth weekday of a month. Hi all, I have a working solution. First I have a solution by a script in Calc. I also have a solution by Calc it self. Both can be found in: https://drive.google.com/open?id=0B8X24IrD0EquTnY4UWR3Q2F4bWM https://drive.google.com/open?id=0B8X24IrD0EquTnY4UWR3Q2F4bWMttp:// Please change the filename from .xxx in .ods For those who are interested in the idea behind the solution in Calc it self: Please make the hidden sheets visible. The basic idea is create a matrix with 7 columns starting on 1-1 Every next rows gets +7 days Count the order from each occurence within a month. Kind regards, Jan Flikweert -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
