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:[email protected] mailto:[email protected] 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: [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
