Category: Carnaval

Eastern

I very much like Carnaval. But since the date of this varies per year because it is related to Eastern, I was looking for a way calculate it. And I found it. Below you see the formulas for Excel:

Copy the fomulas below where “B40” must be in A40  so that the formula after the vertical bar comes in B40.
Separator is vertical bar “|”; list separator  is the semicolon “;”.

Then enter a year like 2001 in cel  A1 and … voilá, Eastern is in B51.

B40|=INT(A1/100)
B41|=A1 - 19*INT(A1/19)
B42|=INT((B40-17)/25)
B43|=B40 - INT(B40/4) - INT((B40-B42)/3) + 19*B41 + 15
B44|=B43-30*INT(B43/30)
B45|=B44-INT(B44/28)*(1-INT(B44/28)*INT(29/(B44+1))) * INT((21-B41)/11)
B46|=A1 + INT(A1/4)+B45+2-B40+INT(B40/4)
B47|=B46 - 7*INT(B46/7)
B48|=B45-B47
B49|=3 + INT((B48+40)/44)
B50|=B48+28-31*INT(B49/4)
B51|=DATE(A1;B49;B50)|Eastern

(Algoritm published in Nature, 1876 April 20, vol. 13, p. 487.)

 

Herman Mol is powered by WordPress.  Staypressed theme by Themocracy