The Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Math Forum » Discussions » sci.math.* » sci.math

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Calendar formula for 2nd Wednesday of each successive month
Replies: 10   Last Post: Jan 27, 2013 12:21 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
Wally W.

Posts: 283
Registered: 6/15/11
Re: Calendar formula for 2nd Wednesday of each successive month
Posted: Jan 26, 2013 10:21 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

On Sat, 26 Jan 2013 22:34:02 +0000, Dr J R Stockton wrote:

>In sci.math message <>, Fri,
>25 Jan 2013 18:00:21, Wally W. <> posted:

>>>And I would guess that there is a general formula for what day is the
>>>1st of the month for the next ten years

>>That would be a list of 120 days.

>A general formula is quite easy. Just consider what is needed for the
>reverse of Zeller's Congruence.

Not as easy as a spreadsheet formula for the purpose.

>One can simplify in this case by using the Julian Calendar, since no
>missing leap year is crossed.
>A spreadsheet is not a particularly good tool for the purpose; in
>Delphi, VBScript, and JavaScript, for example, it will be fairly easy
>(if following an intelligent approach) to find a Web site which has code
>for the "N'th X-day in a Month".

Define "good".

A spreadsheet is quite an effective tool for finding "what day is the
1st of the month."

It may lack the elegance of other methods; but so what?

The spreadsheet formula will be probably accurate until 2099. Nothing
in the problem spec suggests the checks will be issued after that

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.