calculating easter

  • Thread starter Thread starter helmut sager
  • Start date Start date
H

helmut sager

I found the following formula to calculate Easter

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,*7-6

in the book "Excel 2002 Formulas" by John Walkenbach but I allways ge
the info, that there's a mistake in my formula.

Now, I only use Office 2000 on Windows98 SE (both in German). Therefor
this formula needs "translation" into german functions. Anybody ou
there who could give me a hint, how to "correct" this formula, so tha
it works on my PC?

Many thanks for your assistanc
 
Hi Helmut, what does "calculate easter" mean? I am interested in this
formula, but cannot understand what "calculate easter" means.
 
Dave said:
Hi Helmut, what does "calculate easter" mean? I am interested i
this
formula, but cannot understand what "calculate easter" means.


"calculate easter" means how to determine on which date (of eac
year) easter falls
Click to expand...
 
Helmut,

The formula you posted is incorrect, the last parenthesis is missing, and more is missing or mistyped.

Regards,
Anders Silven
 
It's calculating Easter Sunday for the year you type into A1

--

Regards,

Peo Sjoblom

Dave R. said:
Hi Helmut, what does "calculate easter" mean? I am interested in this
formula, but cannot understand what "calculate easter" means.
Click to expand...
 
Helmut,

You can calculate Easter with the following formulas:

For USA style dates (mm/dd/yyyy), use
=FLOOR("5/"&DAY(MINUTE(B2/38)/2+56)&"/"&B2,7)-34

For European style dates (dd/mm/yyyy), use
=FLOOR(DAY(MINUTE(B2/38)/2+56)&"/5/"&B2,7)-34

I can't do the translation to German functions, though. Sorry.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I believe this might be the original for German

=DM((TAG(MINUTE(A1/38)/2+55)&".4."&A1)/7;)*7-6

here are 2 English versions

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6

as you can see there is a missed parenthesis in your version

=FLOOR("5/"&DAY(MINUTE(A1/38)/2+56)&"/"&A1,7)-34
 
Peo said:
I believe this might be the original for German

=DM((TAG(MINUTE(A1/38)/2+55)&".4."&A1)/7;)*7-6

here are 2 English versions

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6

as you can see there is a missed parenthesis in your version

=FLOOR("5/"&DAY(MINUTE(A1/38)/2+56)&"/"&A1,7)-34


--

Regards,

Peo Sjoblom


Hi Peo,
many thanks for the prompt help. Sorry for the missing parenthesis
but even with that one it still doesn't work. Apparently there i
some more information missing, as it doesn't work in the germa
version either.

Regarding your proposal with the function "floor": I couldn't find a
appropriate translation of it. Can you please discribe to me, wha
you can achieve with the function "floor"?

Many thanks in advanc
Click to expand...
 
FLOOR is UNTERGRENZE in German

Strange, both formulas work for me in Swedish.

If not I can email a workbook to you and Excel should do the translation
anyway in Swedish the formulas are

=VALUTA(("4/"&A1)/7+REST(19*REST(A1;19)-7;30)*14%;)*7-6

and

=RUNDA.NER("5/"&DAG(MINUT(A1/38)/2+56)&"/"&A1;7)-34





--

Regards,

Peo Sjoblom

helmut sager said:
Peo said:
I believe this might be the original for German

=DM((TAG(MINUTE(A1/38)/2+55)&".4."&A1)/7;)*7-6

here are 2 English versions

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6

as you can see there is a missed parenthesis in your version

=FLOOR("5/"&DAY(MINUTE(A1/38)/2+56)&"/"&A1,7)-34


--

Regards,

Peo Sjoblom


Hi Peo,
many thanks for the prompt help. Sorry for the missing parenthesis,
but even with that one it still doesn't work. Apparently there is
some more information missing, as it doesn't work in the german
version either.

Regarding your proposal with the function "floor": I couldn't find an
appropriate translation of it. Can you please discribe to me, what
you can achieve with the function "floor"?

Many thanks in advance
Click to expand...
Click to expand...
 
Peo,

Finally I think I've got it!

I have been struggling with the DOLLAR/VALUTA version for over an hour. Got #Value errors whatever I tried on my standard Swedish system.

The formula now works for me with a slight modification:

=VALUTA((A1&"/4")/7+REST(19*REST(A1;19)-7;30)*14%;)*7-6

instead of

=VALUTA(("4/"&A1)/7+REST(19*REST(A1;19)-7;30)*14%;)*7-6

at least for year 2003. What gives? Different date settings?

I was going to ask what the DOLLAR() function has to do with this, but after reading Excel help for the 511th time and knowing the answer I think I understand.

Best regards,
Anders Silven


Peo Sjoblom said:
FLOOR is UNTERGRENZE in German

Strange, both formulas work for me in Swedish.

If not I can email a workbook to you and Excel should do the translation
anyway in Swedish the formulas are

=VALUTA(("4/"&A1)/7+REST(19*REST(A1;19)-7;30)*14%;)*7-6

and

=RUNDA.NER("5/"&DAG(MINUT(A1/38)/2+56)&"/"&A1;7)-34





--

Regards,

Peo Sjoblom

helmut sager said:
Peo said:
I believe this might be the original for German

=DM((TAG(MINUTE(A1/38)/2+55)&".4."&A1)/7;)*7-6

here are 2 English versions

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6

as you can see there is a missed parenthesis in your version

=FLOOR("5/"&DAY(MINUTE(A1/38)/2+56)&"/"&A1,7)-34


--

Regards,

Peo Sjoblom


Hi Peo,
many thanks for the prompt help. Sorry for the missing parenthesis,
but even with that one it still doesn't work. Apparently there is
some more information missing, as it doesn't work in the german
version either.

Regarding your proposal with the function "floor": I couldn't find an
appropriate translation of it. Can you please discribe to me, what
you can achieve with the function "floor"?

Many thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Hi Helmut

In general, you enter a complex english formula into a localized Excel with this little
macro and leave the translation to Excel herself, she's smarter than both of us:

Sub EnterEnglishFormula()
On Error Resume Next
ActiveCell.Formula = _
Trim$(InputBox("English formula:"))
End Sub

Don't translate anything using this, leave . as decimal separators and everything. Worked
fine for your easter formula too once the parentheses was fixed.
 
Back
Top