Re: [libreoffice-users] Calc formula for US Thanksgiving date

2012/12/3 Brian Barker <b.m.barker@btinternet.com>:
> 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: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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