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

Le 28/09/2017 à 14:31, Michael Tiernan a écrit :

Hi Michael,

I started from this :

http://www.dummies.com/software/microsoft-office/excel/calculate-the-date-of-the-nth-weekday-of-the-month-in-excel/

and adjusted it to correspond to the date sequence composition expected
by LibreOffice.

At first,this formula didn't appear to work correctly by just copy/paste
over the whole matrix of cells, but I realized that if I copied the
formula from my first cell across, then in separate copy/paste steps did
each column downwards from the first row, I could get the results I
wanted (at least for the 2nd Tuesday in 2017)



Alex



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