Post Reply 
(17Bii) Finding the first Advent Sunday in a year
12-11-2019, 12:34 PM (This post was last modified: 12-11-2019 07:03 PM by jthole.)
Post: #2
RE: (17Bii) Finding the first Advent Sunday in a year
Here is a shorter (and slightly improved) solution, thanks to Dave Britten:

ADVDATE = DATE( L( XMAS : YEAR รท 1000000 + 25.12 ) : ( ( MOD( DDAYS( 1.011582 : G( XMAS ) : 1 ) : 7 ) + 22 ) x - 1 ) )

Edit: I just realised you could write an even much simpler solution; you just have to find the closest Sunday to November 30.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: (17Bii) Finding the first Advent Sunday in a year - jthole - 12-11-2019 12:34 PM



User(s) browsing this thread: 1 Guest(s)