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

=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 Flikweertjanflikweert@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+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