Well, hope you got the one sent to your direct email. This list doesn't seem to allow either attached spreadsheets or images. Hopefully, others can figure out the formula, or if requested can send anyone a copy of the spreadsheet to an email that will accept it.
The formula seems to handle the problem as I understand it. =$C2+E$1-WEEKDAY($C2)+(E$1<WEEKDAY($C2))*7+7*($B$1-1) On 28 Sep 2017 at 8:31, Michael Tiernan wrote: From: Michael Tiernan <[email protected]> To: [email protected] Subject: [libreoffice-users] Calculating the Nth weekday of a month. Date sent: Thu, 28 Sep 2017 08:31:10 -0400 > Instead of my breaking my neck trying to figure it out, I thought I'd ask. > > Has anyone come up with a macro/formula/method for deriving the date > (YYYY-mm-dd) of the Nth weekday of a month? > > Example: > The second Tuesday of each month of 2017 would be: > 2017-01-10 > 2017-02-14 > 2017-03-14 > etc. > > Thanks for your time in advance. > > -- > 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 +------------------------------------------------------------+ 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 140253615.999240 ROSETTA 63899283.775010 | SETI 109110480.313016 -- 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
