Search
Member List
Calendar
Help
HP Forums
/
HP Software Libraries
/
General Software Library 
/
(17Bii) Finding the first Advent Sunday in a year
/
(17Bii) Finding the first Advent Sunday in a year
|
(17Bii) Finding the first Advent Sunday in a year
|
|
12-11-2019, 10:27 AM
(This post was last modified: 12-11-2019 10:37 AM by jthole.)
Post: #1
|
|||
|
|||
|
(17Bii) Finding the first Advent Sunday in a year
This simple equation returns the date of the first Advent Sunday in a year. For some background info about the Advent period: https://en.wikipedia.org/wiki/Advent
ADVDATE = DATE( L( XMAS : ( YEAR ÷ 1000000 + 25.12 ) ) : RND( ( 7 x FP( DDAYS( 1.0119 : G( XMAS ) : 1 ) ÷ 7 ) + 22 ) x - 1 : 0 ) ) You enter the year, e.g. 2021, and the returned date is (dd.mmyyyy) 28,112021. Another example: year 2025 returns 30,112025. Edit: obviously this doesn't work for dates before January 1, 1900 
11C, 12C, 15C CE, 17Bii, DM42 |
|||
|
|
« Next Oldest | Next Newest »
|
| Messages In This Thread |
|
(17Bii) Finding the first Advent Sunday in a year - jthole - 12-11-2019 10:27 AM
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)