View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Easter day formula

hi, JLatham !

I got curious about all of this and did a lot of research and testing.
The results of the tests indicate that the formula just provided is valid for all years from 1900 through 2033
with the exception that it gives a wrong answer in 2079. Years after 2033 generate irregular errors.
The following change to that formula will provide uninterrupted correct results from 1900 through 2033:
=IF(A3<2079,FLOOR(DATE(A3,5,DAY(MINUTE(A3/38)/2+56)),7)-34,FLOOR(DATE(A3,5,DAY(MINUTE(A3/38)/2+57)),7)-34)


it's a great development, thanks for sharing it :D

also, it is possible a little streamlining to the formula and avoid the 'conditional' IF function [same results]...
=floor(date(a3,5,day(minute(a3/38)/2+56+(a3=2079))),7)-34

my US $0.02
regards,
hector.

Essentially, in 2079 we have to add 1 week into the formula. References are
http://aa.usno.navy.mil/faq/docs/easter.html
and the table at
http://www.smart.net/~mmontes/freq3.html

The results of my research can be seen in this workbook at my site:
http://www.jlathamsite.com/uploads/E...omparisons.xls

Enjoy!