Forum for Hebcal.com - Free Jewish holiday calendars, Hebrew date converters and Shabbat times
+7

Access to HEBCAL data from within google sheets

David Kra 4 years ago updated by Adam Simon 3 months ago 2

This is a tip, not a question nor complaint.

It is possible to access Hebcal data from within google sheets through the XML API.

For example,

=IMPORTXML("https://www.hebcal.com/converter/?cfg=xml&hy=5780&hm=Adar&hd=25&h2g=1","//hebcal/gregorian/@month") 
=IMPORTXML("https://www.hebcal.com/converter/?cfg=xml&hy=5780&hm=Adar&hd=25&h2g=1","//hebcal/gregorian/@day") 

The result becomes the value of the cell.

You can get multiple result values in one query. The the first result value goes into the cell with the formula, and others go below it, into cells which must be empty, with neither a formula nor a value already in them. This makes it unfeasible for one query to fill in multiple columns in a table.

=IMPORTXML("https://www.hebcal.com/converter/?cfg=xml&hy=5780&hm=Adar&hd=25&h2g=1","//hebcal/gregorian/@month|//hebcal/gregorian/@day") 

Do not overburden hebcal.com with a blast of hundreds of queries when the sheet loads or recalculates. Throttle usage by putting the query into an IF so that it only fires if some condition is TRUE.

For example:

=IF($AN8,IMPORTXML("https://www.hebcal.com/converter/?cfg=xml&h2g=1&hy="&AO8&"&hm="&AP8&"&hd="&AQ8,"//hebcal/gregorian/@day")," ")

where

AN8 is TRUE or FALSE

AO8 is the Jewish year

AP8 is the Jewish month

AQ8 is the Jewish day of the month


Thank you to the people at Hebcal. Mo'adim L'simchah.

+6
Answered

Creating recurring events using a Hebrew date

Ari Witkin 6 years ago updated by Michael J. Radwin 3 years ago 2

Is it possible to create a recurring event on a google calendar that has been synched with Hebcal that is based on the Hebrew date but will match us with the english date in future years? For example, if I wanted to input an annual event on the 9th of Iyar would that be feasible? 

Answer
Michael J. Radwin 3 years ago

Hi, thanks for using Hebcal.

Our yahrzeit, birthday and anniversary calendar be used to do that. It lets you generate a list of Yahrzeit dates, Hebrew Birthdays, and Hebrew Anniversaries.


You can print, subscribe to annual email reminders, and download a multi-year calendar feed to Apple, Google, Outlook, and more.

If you know the Hebrew but not the Gregorian date, use the Hebrew Date Converter to get the Gregorian date and then come back to the anniversary tool.


+5
Planned

How to calculate the number of days between two dates on the Jewish calendar.

tomajo jmt 3 years ago updated by Michael J. Radwin 3 years ago 1

Hi, I would like to make a suggestion. It would be interesting to have a way to calculate the number of days between two dates on the Jewish calendar. I study biblical prophecies and we often need to know this information.

I would be immensely grateful.

+5

Yom Tov support for Google Calendar

Saar 6 years ago updated by dstat 5 years ago 4

Would be really cool to add support for identifying which day is Yom Tov and work should be avoided and which day is a normal holiday where work is permitted.

When exporting the calendar to Google Calendar, it shows all the dates as a single color with the same description

Possible ways to improve: 

1. Change color of yom tov holiday something different than default color

Or

2. Add a note to the yom tov holidays stating that it is a yom tov.


For example, Pesach is coming up and all the days are the same on my calendar. Would be nice to have a way to identify that the first two days and last two days are different

+5
Under review

Haftarah Ki Teitzei incorrect when Re'eh is Shabbat Rosh Chodesh

Avraham Eisen 6 years ago updated by Michael J. Radwin 3 years ago 2

The website is showing the incorrect Haftarah for Ki Teitzei when Parshat Re'eh is Shabbat Rosh Chodesh.  If the website is going to say that the Haftarah for Shabbat Rosh Chodesh is read for Parshat Re'eh, then the Haftarah for Ki Teitzei should show that it's Isaiah 54:1 - 55:5.


I know there are a few different traditions for when this happens, but there's no such tradition where the Haftarah for Shabbat Rosh Chodesh is read for Parshat Re'eh, and the Haftarah for Parshat Ki Teitzei remains unchanged (54:01 - 54:10), as the website currently displays.

+3
Started

Ashkenaz transliteration of Tazria as Sazria

BridgeyBoi 1 year ago updated by Michael J. Radwin 7 months ago 1

Maybe I'm missing something, but I've never heard anyone pronounce תַזְרִיעַ as Sazria.  

Can the Ashkenaz transliteration be updated to Tazria?

Loving the software and great APIs, thank you!

+3
Searching answer

Starting from April 2020 events span 2 days on my Outlook

David Lapin 4 years ago updated by Michael J. Radwin 3 years ago 1

Starting from April 2020 events like Hebrew date, daf yomi etc, span 2 days on my Outlook on my desktop and mobile (but not on the online version). Seems the events are 24 hours instead of all day for a single day. Any advice how to correct? 

Answer
Michael J. Radwin 3 years ago

Hi, can you please let us know if this continues to be a problem? We have made some changes to how Outlook events are generated from Hebcal and we believe we have fixed the issue.

+3
Completed

How do I renew this? It stops at 2019!!!

rorsiba 4 years ago updated by Michael J. Radwin 3 years ago 3
Answer
Michael J. Radwin 3 years ago

Hi, thanks for using Hebcal!

Follow these instructions to subscribe to a new Hebcal Jewish Calendar multi-year feed directly from your iPhone or iPad:

https://www.hebcal.com/home/77/iphone-ipad-jewish-holidays

+3
Fixed

No Havdalah event on 12/28/2019

Daniel Segall 4 years ago updated by Michael J. Radwin 3 years ago 2
Answer
Michael J. Radwin 3 years ago

Hi, thanks for the feedback.

We've made changes to how our API works and Chanukah candle-lighting times will no longer suppress regular Shabbat/Havdalah times. Here's an example to illustrate how the API now behaves (with 2 events on Friday night and 2 events on Saturday night).

https://www.hebcal.com/hebcal/?v=1&cfg=json&maj=on&min=off&mod=off&nx=off&year=2019&month=12&ss=off&mf=off&c=on&geo=zip&zip=11581&m=47&s=off&b=18&leyning=off

    {
      "title": "Candle lighting: 4:16pm",
      "date": "2019-12-27T16:16:00-05:00",
      "category": "candles",
      "title_orig": "Candle lighting",
      "hebrew": "הדלקת נרות"
    },
    {
      "title": "Chanukah: 7 Candles",
      "date": "2019-12-28T17:22:00-05:00",
      "category": "holiday",
      "subcat": "major",
      "hebrew": "חנוכה: ז׳ נרות",
      "link": "https://www.hebcal.com/holidays/chanukah-2019?utm_source=js&utm_medium=api",
      "memo": "Hanukkah, the Jewish festival of rededication. Also known as the Festival of Lights"
    },
    {
      "title": "Havdalah (47 min): 5:22pm",
      "date": "2019-12-28T17:22:00-05:00",
      "category": "havdalah",
      "title_orig": "Havdalah",
      "hebrew": "הבדלה (47 דקות)"
    },
    {
      "title": "Chanukah: 8 Candles",
      "date": "2019-12-29T17:07:00-05:00",
      "category": "holiday",
      "subcat": "major",
      "hebrew": "חנוכה: ח׳ נרות",
      "link": "https://www.hebcal.com/holidays/chanukah-2019?utm_source=js&utm_medium=api",
      "memo": "Hanukkah, the Jewish festival of rededication. Also known as the Festival of Lights"
    }
+3
Fixed

BC converter no longer works - even with the 10day accuracy warning - how can we use an older version of the website?!

irish 4 years ago updated by Michael J. Radwin 3 years ago 3

what good reason could you possibly have to break your own converter? your BC Hebrew/Gregorian converter no longer works - even with your CYA "10day accuracy" warning - how can we get it back or use an older version of the website?!

Answer
Michael J. Radwin 3 years ago

The Hebrew Date Converter now supports BCE dates

https://www.hebcal.com/converter?hd=11&hm=Sivan&hy=1234&h2g=1

11th of Sivan, 1234 = Sat, 9 May 2526 B.C.E.