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 [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 Attachments: Z:\home\msetzerii\nthweekday.ods -- 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
