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

Not sure what messed up the contents, but what I got had a number changes 
from the original message?? So, trying again, with just straight text.

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 

Saved CSV version
Row 1: Year,2017,,

Row 2: 
Month,1,January,"=CHOOSE(B2,"January","February","March","Apri","May","
June","July","August","September","October","November","December")

Row 3:
Day,1,Sunday,"=CHOOSE(B3,"Sunday","Monday","Tuesday","Wednesday","
Thursday","Friday","Saturday")

Row 4:
Week,1,First,"=CHOOSE(B4,"First","Second","Third","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))+(B3<WEEKDAY(DATE(B
1,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


Note sure how changed the text. Just Months of year, and days of week for 
text display

Wish list would allow for attachments. Have another one that uses a table 
format, but uses the same kind of formula.

+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 http://www.guam.net/home/mikes
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS

ABC          16613838.513356 | EINSTEIN    140296137.999240
ROSETTA      64023631.925288 | SETI        109144594.967005


-- 
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