On Thursday, August 6, 2009 at 4:51:01 AM UTC+1, JLatham wrote:
Rather than take credit (or blame) for this, I'll point you to a site I found
with code to do Gregorian to Hebrew and Hebrew to Gregorian date conversions:

http://www.geocities.com/DafAWeek/HebCalVb6.html

To put the code into your workbook: Open the workbook. Press [Alt]+[F11] to
open the VB Editor. Use Insert -- Module to create a new code module. Copy
the code from the web site into the module. Close the VB Editor.

To use it, easiest to choose a column next to your list of dates and
(assuming your list is in column A and begins on row 2), in another column on
row 2, put the formula:
=DateToHeb(A2)
it will actually show up as =datetoheb(A2) in the formula bar. Anyhow, the
Hebrew calendar day will appear in the cell where you put that formula.

I have tried the code, it works without any runtime error, but I have not
verified the accuracy of the results. There are numerous online
Gregorian-to-Hebrew calendar sites (search for 'convert gregorian to hebrew'
to get a list), so you can enter some of your dates in them and see if their
results verify what the formula has provided.
Hope this helps.


"Joe Golden" wrote:

I have an excel table of dates of death that I need to convert to Hebrew
calendar preferably in a single column formula which then can be exported to
Word for letters to relatives each year for yahrzeit reminders..



I know this was from a while a go but am hoping you can still help me.

I have followed your instructions to 'put the code into your workbook' but this is not working. I have several lines in the macro which are shown in red. Am I right in thinking that this is an issue? Am I supposed to be editing part of this script for what I am doing?