2012/12/3 Brian Barker <[email protected]>: > At 05:58 03/12/2012 -0500, Dottie Noname wrote: >> >> I need a formula for Calc to determine the US Thanksgiving date for a >> given year. > > > I could have answered this sooner but resisted at first because of the > unfriendly - frankly selfish - habit of suppressing any name. How is anyone > to refer to you? How is anyone to search for your previous messages? It > doesn't matter if you use your real name or not: call yourself Albert > Einstein or Mickey Mouse or Algernon Cholmondeley-Featherstonehaugh if you > wish, but please remember that you are asking for help and grant everyone > the courtesy of giving yourself some sort of usable handle. Thank you. > </soapbox> > > It's not exactly clear what you want here: for this year, for example, would > you like the result to be the integer 22 or the date value 22 November 2012? > (I'm guessing probably the latter.) > > For the integer: > =29-WEEKDAY(DATE(Xn;11;3)) > or for the date value: > =DATE(Xn;11;29)-WEEKDAY(DATE(Xn;11;3))
He he he… that was a lot more elegant than my version! Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > In each case, Xn is the cell with the relevant year. In the second case, > the result cell will have to be appropriately formatted in order to display > as you will wish. > > I trust this helps. > > Brian Barker > > > > -- > For unsubscribe instructions 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 > -- For unsubscribe instructions 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
