Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default Rosh Hashanah and Yom Kippur Holiday Dates Revisited

On Mon, 28 Jan 2008 20:18:16 -0800, jnf40
wrote:

Ron Rosenfeld,

I found the following code that works up until I enter the Gregorian year
2024 (fiscal year), molad 5784, then it shows Rosh Hashanah beginning sundown
of 9/16/2023 and ending 9/18/2023 with Yom Kippur on 9/25/2023. The calendar
at http://www.jewfaq.org/calendar.htm however shows Rosh Hashanah beginning
sundown of 9/15/2023 and ending 9/17/2023 with Yom Kippur on 9/25/2023. Also
read after code:


jnf40,

Personally, I use Calendar Creator to obtain the dates of Jewish Holidays. Its
built-in algorithm seems to work.

It, too, shows Rosh Hashanna beginning on the evening of 15 Sep 2023 and Yom
Kippur starting on the evening of 24 Sep 2023. So I would say the web site and
Calendar Creator are correct.

There is also an interactive calendar at http://www.hebcal.com/ with the
capability of downloading the results into various formats, including CSV file
(designed for Outlook but opens fine in Excel).
--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rosh Hashanah and Yom Kippur jnf40 Excel Programming 3 January 25th 08 01:20 AM
Holiday rules for Memorial Day Dates OC Excel Discussion (Misc queries) 18 September 1st 07 02:34 AM
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
VBA Function that ignores dates in a Holiday Table Sorbit Excel Worksheet Functions 0 January 17th 06 10:03 PM
Holiday Dates Alpur Excel Worksheet Functions 3 November 16th 05 06:14 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"