Hi Hector,

Do you know the formula also for date format yyyy/mm/dd? If so, please let
me know it!
Thanks,
Stefi

€žHéctor Miguel€� ezt Ã*rta:

hi, Antonio !
[just in case you don't come-back to spanis-ng] :))

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.