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.