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

Attempt with attachment didn't seem to go thru, so sending just the message with this one.


See if this is what you are looking for.


=$C2+E$1-WEEKDAY($C2)+(E$1WEEKDAY($C2))*7+7*($B$1-1)


Is the formula I put in E2, and copied from E2 to K13


B1 contains the number of the occurance.
A2-A13 has year
B2-B13 has the month of year
C2-C13 has the date of the first day of month showing the day of week.
D2-D13 has the day of week for that date.


E1-K1 has the days of Week 1 - 7 (Sun to Mon)
E2-K13 has the forumula above.
E16-K17 has the weekday formula to confirm the date is matching the day of 
week for the column.


Tried it with Nth of 1 to 5, and it seems to work in my test. If a month doesn't 
have 5 of that day of week, it does give the day of ween for the next month.


Pasted the cells, but not sure it will get thru the email process. Know the list 
doesn't take attachments to list, but will attache the spreadsheet for your 
email.


nth
1




1
2
3
4
5
6
7
2017
1
Sunday, January 1, 2017
1
01/01/17
01/02/17
01/03/17
01/04/17
01/05/17
01/06/17
01/07/17
2017
2
Wednesday, February 1, 2017
4
02/05/17
02/06/17
02/07/17
02/01/17
02/02/17
02/03/17
02/04/17
2017
3
Wednesday, March 1, 2017
4
03/05/17
03/06/17
03/07/17
03/01/17
03/02/17
03/03/17
03/04/17
2017
4
Saturday, April 1, 2017
7
04/02/17
04/03/17
04/04/17
04/05/17
04/06/17
04/07/17
04/01/17
2017
5
Monday, May 1, 2017
2
05/07/17
05/01/17
05/02/17
05/03/17
05/04/17
05/05/17
05/06/17
2017
6
Thursday, June 1, 2017
5
06/04/17
06/05/17
06/06/17
06/07/17
06/01/17
06/02/17
06/03/17
2017
7
Saturday, July 1, 2017
7
07/02/17
07/03/17
07/04/17
07/05/17
07/06/17
07/07/17
07/01/17
2017
8
Tuesday, August 1, 2017
3
08/06/17
08/07/17
08/01/17
08/02/17
08/03/17
08/04/17
08/05/17
2017
9
Friday, September 1, 2017
6
09/03/17
09/04/17
09/05/17
09/06/17
09/07/17
09/01/17
09/02/17
2017
10
Sunday, October 1, 2017
1
10/01/17
10/02/17
10/03/17
10/04/17
10/05/17
10/06/17
10/07/17
2017
11
Wednesday, November 1, 2017
4
11/05/17
11/06/17
11/07/17
11/01/17
11/02/17
11/03/17
11/04/17
2017
12
Friday, December 1, 2017
6
12/03/17
12/04/17
12/05/17
12/06/17
12/07/17
12/01/17
12/02/17




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




1
2
3
4
5
6
7




On 28 Sep 2017 at 8:31, Michael Tiernan wrote:


From:Michael Tiernanmichael.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




Attachments: Z:\home\msetzerii\nthweekday.ods


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