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

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 <michael.tiernan@gmail.com>
To:                     users@global.libreoffice.org
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: 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


+------------------------------------------------------------+
 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    140253615.999240
ROSETTA      63899283.775010 | SETI        109110480.313016


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