On Thu, 24 Jan 2008 13:25:48 -0800, jnf40
wrote:

Does anyone know how I would find the dates that Rosh Hashanah and Yom Kippur
are on by using a given date? Right now I have a workbook that sets up a
timesheet for the year. Due to the layout of the timesheet I would need to
have the date of Rosh Hashanah and Yom Kippur be placed in a cell then
compare this date to the day on the timesheet to perform the formatting to
show the holiday. When the workbook starts the first sheet is always
September and then the workbook ends in August of the next year, all the user
is required to do is enter the Fiscal year. So for example the user would
enter 2008 and the workbook would contain the worksheets Sep_2007 through
August_2008. I was able to get all the other holidays I needed, but am having
trouble with these two. I am using Excel 2003. I have looked on line but all
the things I have found I can't figure out how to incorprate them into my
code, it looks like a lot of various functions are needed and most are
written for another version of VBA, I believe. Any and all help is greatly
appreciated.


Calculating Hebrew dates is extremely complicated. I believe the simplest
procedure for you would be a lookup table.

It would take you a lot less time to enter the dates for the next ten-twenty
years than to program to calculate these dates.
--ron