Here's the correct algorithmn for month without the cell references:
Month=INT(INT(MOD(((19*MOD(Year,19))+ INT(Year/100) - INT(INT(Year/100)/4) -
INT((INT(Year/100) - INT((INT(Year/100) +
8)/25) + 1)/3) + 15),30)+MOD((32+(2*MOD(INT(Year/100),4))+(2 *
INT(MOD(Year,100)/4))-MOD(((19 *
MOD(Year,19))+INT(Year/100)- INT(INT(Year/100)/4) - INT((INT(Year/100)-
INT((INT(Year/100)+ 8)/25) + 1)/3)
+15),30)-MOD(MOD(Year,100),4)),7)-7*INT((MOD(Year,19)
++(11*MOD(((19*MOD(Year,19))+INT(Year/100)-
INT(INT(Year/100)/4) - INT((INT(Year/100)- INT((INT(Year/100)+ 8)/25) +1)/3)
+15),30))+ (22* MOD(((19* MOD(Year,19))+
INT(Year/100) - INT(INT(Year/100)/4) - INT((INT(Year/100)- INT((INT(Year/100) + 8)/25)
+1)/3) +15),30)))/451)+114)/31)
----- Original Message -----
From: "Hurd, Richard A (Rich)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 9:18 AM
Subject: Re: EDI dates
> I was waiting for this.
>
> > The algorithms are the stuff of nightmares. In some cases you end up
> > with external lookup tables which have to be refreshed 'manually' every
> > year or two, plus useful lists of the public holidays in most major
> > industrialised countries! The use of external tables is a cop-out, but
> > things like the algorithmic calculation of Easter (The first Sunday
> > after the first full moon after the Vernal Equinox) can be very tedious.
> >
> >
> http://www.smart.net/~mmontes/butcher.html
>
> I used to be involved in automating an MVS data center for Merrill Lynch.
> One of the biggest tasks we had for the production jobstream was modifying
> the JCL with date parameters. I was on the team that wrote a program to
> modify the JCL date parameters, but it had to pre-calculate all the dates in
> order to figure out what dates to insert. (Being a brokerage house, one of
> the dates that we needed to insert was Good Friday which is a bank holiday.
> The only thing we were sure about before we had this algorithm was that it
> was Easter-2.)
>
> We didn't use this algorithm exactly, since the guy doing it didn't have
> Internet access (this was 1981, fer Pete's sake.) He got the algorithm by
> going to the NY Public Library and doing the research.
>
> I did it by typing "calculating the date of Easter" in Google. How far
> we've come!
>
> =======================================================================
> To contact the list owner: mailto:[EMAIL PROTECTED]
> Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
>
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
