Access to HEBCAL data from within google sheets
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.
Creating recurring events using a Hebrew date
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?
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.
How to calculate the number of days between two dates on the Jewish calendar.
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.
Yom Tov support for Google Calendar
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
Haftarah Ki Teitzei incorrect when Re'eh is Shabbat Rosh Chodesh
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.
Starting from April 2020 events span 2 days on my Outlook
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?
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.
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:
No Havdalah event on 12/28/2019
The following API call returns no Havdalah event on December 28, 2019:
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).
{
"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"
}
BC converter no longer works - even with the 10day accuracy warning - how can we use an older version of the website?!
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?!
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.
Customer support service by UserEcho
