How can I convert column of dates to Hebrew dates

[Joe Golden]

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..

 

[JLatham]

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.

 

[JLatham]

I did compare just a few dates and they agreed with a site I checked them on,
but it revealed a "flaw" in the process. This site,
http://www.hebcal.com/converter/ , brought that to my attention.

The formula assumes that you're asking about a date before sundown on that
date.

That is, if you use the Gregorian date of 5 AUG 2009, the formula returns Av
15 5769. That is correct UNTIL sundown on 05 Aug 2009. After sunset the
correct answer is Av 16 5769.

 

[jenstosser]

I don't suppose you'd be able to post the code here? The Geocities website no longer exists, so I can't get the code from there, and I need to do this task too!
Thanks
Jen

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.

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..

 

[Ron Rosenfeld]

I don't suppose you'd be able to post the code here? The Geocities website no longer exists, so I can't get the code from there, and I need to do this task too!
Thanks
Jen

This is a link to an Excel add-in that will convert all kinds of date systems; http://en.pudn.com/downloads383/doc/detail1645293_en.html

 

[Gord Dibben]

See this discussion for code and pertinent info.

http://answers.microsoft.com/en-us/...rew-date/4426060a-620e-4763-8671-d39194e4550a


Gord

I don't suppose you'd be able to post the code here? The Geocities website no longer exists, so I can't get the code from there, and I need to do this task too!
Thanks
Jen

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.

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..

 

[Ron Rosenfeld]

Have you been able to develop a solution. I am just starting on an effort with the same intent. Thanks in advance for any insight you can offer.

You can use the excellent, but currently non-supported calmath add-in for Excel. Get it here: http://members.casema.nl/couprie/calmath/download/

However, the Help file is in an old format and, if you are running a version of Windows older than Vista, you will need to download the appropriate WinHLP32.exe file from Microsoft. See: http://support.microsoft.com/kb/917607

 

[Ron Rosenfeld]

However, the Help file is in an old format and, if you are running a version of Windows older than Vista, you will need to download the appropriate WinHLP32.exe file from Microsoft. See: http://support.microsoft.com/kb/917607

That should read ...UNLESS you are running a version of Windows older than Vista, ...