I found a shorter formula here
=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6
but it gives, incorrect results after year 2203
Also see The Date of Easter
I found a shorter formula here
=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6
but it gives, incorrect results after year 2203
Also see The Date of Easter
Last edited by DocAElstein; 07-11-2023 at 11:47 AM.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks