eater day formula

hi, Antonio !

easter day formula Excel Sample Spreadsheets in spanish
'=FLOOR(DAY(MINUTE(IJ20/38)/2+56)&"/5/"&IJ20,7)-34
'=FRANC((JOUR(MINUTE(A1/38)/2+55)&"/4/"&A1)/7;)*7-6
This is what i have but does not work in spanish

1) based on the 'original' winning formula in Hans W. Herber's competition [english]
-> =floor(day(minute(a1/38)/2+56)&"/5/"&a1,7)-34
and assuming 'A1' holds 4 digits year for easter sunday...

2) direct translation for spanish formula is:
-> =multiplo.inferior(dia(minuto(a1/38)/2+56)&"/5/"&a1,7)-34
== [however]... you need to pay attention to 'date order'
-> which depends on country / regional settings in the windows control panel [user / pc]

3) 'original' formula is 'assuming' a date order of: dd/mm/yyyy
in 'my' case... I needed to switch that 'date order' into: mm/dd/yyyy
and the working fornula becomes to:
=multiplo.inferior("5/"&dia(minuto(a1/38)/2+56)&"/"&a1,7)-34

hth,
hector.

Hi guys,

Just a suggestion: since we are no longer in a contest for the shortest
formula possible (I doubt we can ever compete with the German version of the
DOLLAR function DM though :-)), I guess the following formula would get the
regional issue out of the way:

=FLOOR(DATE(A1,5,DAY(MINUTE(A1/38)/2+56)),7)-34
=MULTIPLO.INFERIOR(FECHA(A1;5;DIA(MINUTO(A1/38)/2+56));7)-34

My two cents,
KL


"Héctor Miguel" wrote in message
news:

hi, Antonio !

easter day formula Excel Sample Spreadsheets in spanish
'=FLOOR(DAY(MINUTE(IJ20/38)/2+56)&"/5/"&IJ20,7)-34
'=FRANC((JOUR(MINUTE(A1/38)/2+55)&"/4/"&A1)/7;)*7-6
This is what i have but does not work in spanish

1) based on the 'original' winning formula in Hans W. Herber's competition
[english]
-> =floor(day(minute(a1/38)/2+56)&"/5/"&a1,7)-34
and assuming 'A1' holds 4 digits year for easter sunday...

2) direct translation for spanish formula is:
-> =multiplo.inferior(dia(minuto(a1/38)/2+56)&"/5/"&a1,7)-34
==> [however]... you need to pay attention to 'date order'
-> which depends on country / regional settings in the windows control
panel [user / pc]

3) 'original' formula is 'assuming' a date order of: dd/mm/yyyy
in 'my' case... I needed to switch that 'date order' into: mm/dd/yyyy
and the working fornula becomes to:
=multiplo.inferior("5/"&dia(minuto(a1/38)/2+56)&"/"&a1,7)-34

hth,
hector.

hi, all !

I believe that it is an appropriate solution besides that OP,
once he knows the 'reason', he will be able to find the 'how to' ;)

regards,
hector.

Hi guys,

Just a suggestion: since we are no longer in a contest for the shortest formula possible (I doubt we can ever compete with the German version of the DOLLAR function DM though :-)), I guess the following formula would get the regional issue out of the way:

=FLOOR(DATE(A1,5,DAY(MINUTE(A1/38)/2+56)),7)-34
=MULTIPLO.INFERIOR(FECHA(A1;5;DIA(MINUTO(A1/38)/2+56));7)-34

My two cents,
KL

"Héctor Miguel" wrote in message news:
hi, Antonio !

easter day formula Excel Sample Spreadsheets in spanish
'=FLOOR(DAY(MINUTE(IJ20/38)/2+56)&"/5/"&IJ20,7)-34
'=FRANC((JOUR(MINUTE(A1/38)/2+55)&"/4/"&A1)/7;)*7-6
This is what i have but does not work in spanish

1) based on the 'original' winning formula in Hans W. Herber's competition [english]
-> =floor(day(minute(a1/38)/2+56)&"/5/"&a1,7)-34
and assuming 'A1' holds 4 digits year for easter sunday...

2) direct translation for spanish formula is:
-> =multiplo.inferior(dia(minuto(a1/38)/2+56)&"/5/"&a1,7)-34
==>> [however]... you need to pay attention to 'date order'
-> which depends on country / regional settings in the windows control panel [user / pc]

3) 'original' formula is 'assuming' a date order of: dd/mm/yyyy
in 'my' case... I needed to switch that 'date order' into: mm/dd/yyyy
and the working fornula becomes to:
=multiplo.inferior("5/"&dia(minuto(a1/38)/2+56)&"/"&a1,7)-34

hth,
hector.

Hola amigos:
Parece muy interesante la formula que habeis
traducido.
Debe ser algo relacionado con los siempre complejos calculos que sobre
fechas
acostumbrais a responder, y los demas, entre los que me incluyo, a aprender.
Parece algo relacionado con el dia de pascua y una formula ganadora de algun
premio.
Como la curiosidad es muy intensa, podrías ampliarnos la información sobre
su empleo en castellano?.
Parece muy brillante.

Gracias. Gavillas.

"Héctor Miguel" escribió en el mensaje
news:#

hi, all !

I believe that it is an appropriate solution besides that OP,
once he knows the 'reason', he will be able to find the 'how to' ;)

regards,
hector.

> Hi guys,
>
> Just a suggestion: since we are no longer in a contest for the shortest

formula possible (I doubt we can ever compete with the German version of the
DOLLAR function DM though :-)), I guess the following formula would get the
regional issue out of the way:

>
> =FLOOR(DATE(A1,5,DAY(MINUTE(A1/38)/2+56)),7)-34
> =MULTIPLO.INFERIOR(FECHA(A1;5;DIA(MINUTO(A1/38)/2+56));7)-34
>
> My two cents,
> KL
>
>> "Héctor Miguel" wrote in message

news:

>> hi, Antonio !
>>
>>> easter day formula Excel Sample Spreadsheets in spanish
>>> '=FLOOR(DAY(MINUTE(IJ20/38)/2+56)&"/5/"&IJ20,7)-34
>>> '=FRANC((JOUR(MINUTE(A1/38)/2+55)&"/4/"&A1)/7;)*7-6
>>> This is what i have but does not work in spanish
>>
>> 1) based on the 'original' winning formula in Hans W. Herber's

competition [english]

>> -> =floor(day(minute(a1/38)/2+56)&"/5/"&a1,7)-34
>> and assuming 'A1' holds 4 digits year for easter sunday...
>>
>> 2) direct translation for spanish formula is:
>> -> =multiplo.inferior(dia(minuto(a1/38)/2+56)&"/5/"&a1,7)-34
>> ==> >> [however]... you need to pay attention to 'date order'
>> -> which depends on country / regional settings in the windows

control panel [user / pc]

>>
>> 3) 'original' formula is 'assuming' a date order of: dd/mm/yyyy
>> in 'my' case... I needed to switch that 'date order' into:

mm/dd/yyyy

>> and the working fornula becomes to:
>> =multiplo.inferior("5/"&dia(minuto(a1/38)/2+56)&"/"&a1,7)-34
>>
>> hth,
>> hector.

hola, Gavillas !

... interesante la formula
... Parece algo relacionado con el dia de pascua y una formula ganadora de algun premio.
... la curiosidad es... intensa, podrias ampliarnos la informacion sobre su empleo en castellano?.

[en efecto] se trata de un concurso llevado a cabo tiempo atras
para encontrar la formula mas corta posible [en caracteres y llamadas a funciones]

en cuanto a su 'aplicacion' [en cualquier idioma], fuera de encontrar fechas festivas especiales... ???
prueba iniciando una visita por: -> http://www.cpearson.com/excel/holidays.htm
[entre otros sitios mas con informacion al respecto] :))

saludos,
hector.