Now we just need to be able to convert the Serial Number to a proper date format:
To make it all one formula:
That should do it.
Another possibility, since the rule makes pre-calculation of the date fairly certain, is to run the formula in Excel for a number of years and then use the resulting information for a lookup, either internal or external.
Creating an internal lookup would allow the potential for storing the Easter Dates object in a central model ready to re-use whenever it is required.
Just a thought.
Thank you for translating the formula. It works beautifully.
BTW, for those following, the Excel formula translated was another Excel formula that calculates Easter and it is:
I also like the idea of lookups because less computations means more efficient models.