Who can explain the formula to calculate the date of Easter

W

Walibi

I found two formulas, there are more but these obsess me:
English: =DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1;19)-7;30)*14%;)*7-6
Dutch: =EURO(("4/"&A1)/7+REST(19*REST(A1;19)-7;30)*14%;)*7-6
To explain the formula in Excel, I don't understand the following functions:
The DOLLAR or EURO to calculate a date?
And (“4/”&A1)/7 where A1 is 2010.
So between brackets we have in fact a text (4/2010)/7, and that divided by 7?
If I make the calculation according the hierarchy of the brackets I find 0.000284292.
If Excel makes the calculation the result is 5752.714286.
Nevertheless the formula to calculate the date of Easter is correct.

Who can explain that?

Thanks to all for help.
 
G

Glenn

Walibi said:
I found two formulas, there are more but these obsess me:
English: =DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1;19)-7;30)*14%;)*7-6
Dutch: =EURO(("4/"&A1)/7+REST(19*REST(A1;19)-7;30)*14%;)*7-6
To explain the formula in Excel, I don't understand the following functions:
The DOLLAR or EURO to calculate a date?
And (“4/”&A1)/7 where A1 is 2010.
So between brackets we have in fact a text (4/2010)/7, and that divided by 7?
If I make the calculation according the hierarchy of the brackets I find 0.000284292.
If Excel makes the calculation the result is 5752.714286.
Nevertheless the formula to calculate the date of Easter is correct.

Who can explain that?

Thanks to all for help.



--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Beta 6
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -
Click to expand...

On this page:

http://www.cpearson.com/excel/Easter.aspx

is a formula that uses FLOOR, DAY and MINUTE, as well as some VBA.
 
Top