Hebrew Date Converter provides two custom functions that convert a date to its corresponding Hebrew date and Jewish events.
By:
Works with:
19K+
Overview
HEBDATE: converts (Gregorian) date to Hebrew date. Provides two additional & optional parameters for selecting after-sunset ("Shkiah") and/or Hebrew font result.

HEBEVENTS: returns Jewish events - including weekly Torah Parsha and Jewish holidays - corresponding to the date provided. Provides after-sunset option as well.

*Please leave your positive feedback if you enjoy the add-on functions*

Attribution: this add-on uses partially the https://www.hebcal.com Hebrew Date Converter REST API by mradwin that is under Creative Commons Attribution 3.0 License. But is NOT endorsed by them in any way. Special thanks to M.L. for her contribution to this project.
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
ReportFlag as inappropriate
Hebrew Date Converter will ask for the permissions shown below. Learn more
Hebrew Date Converter will need access to your Google account
This will allow Hebrew Date Converter to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Chaya Rabinowitz
August 28, 2023
I installed it recently but it doesn't work and never did. I see Yehoshua Kahan had the same issue recently. Anyone else? Would love to change this to a positive review when I see it working. Thanks!
Is this review helpful?
Yes
No
Profile Picture
David Frankfurter
September 19, 2023
Doesn't work. Others report the same issue. Will uninstall. Will be pleased to hear that it has been fixed & will reinstall and update review accordingly.
Is this review helpful?
Yes
No
Profile Picture
Yehoshua Kahan
May 11, 2023
Although I have it installed, my Google Sheets is not recognizing either HEBDATE or HEBEVENTS. I don't understand what's the problem. It did work at first, then suddenly stopped. I liked it while it lasted.
Is this review helpful?
Yes
No
Profile Picture
Avraham Ben Emanuel
May 3, 2023
Great, would enjoy a function to calculate if birthday is in the next 30 days. This is what I use for Gregorian dates =IF(AND(MONTH(D3)=MONTH(TODAY()), DAY(D3)>=DAY(TODAY()), DAY(D3)<=DAY(TODAY())+30),CONCAT("🎂",G3+1),"")
Is this review helpful?
Yes
No
Profile Picture
yitzchok lobenstein
December 31, 2023
Although I have it installed, my Google Sheets is not recognizing either HEBDATE or HEBEVENTS. I don't understand what's the problem.
Is this review helpful?
Yes
No
Profile Picture
shlomik shlomik
July 9, 2021
Thank you so much for this cool add-on. Wondered if it is possible to have the HEBEVENTS function in Hebrew. Please consider that... Thanks a lot תזכו למצוות
Is this review helpful?
Yes
No
Profile Picture
A User of Hebrew Date Converter
February 16, 2020
I would like to ask the owner of this AddOn to remove the Isreali holidays (like "Yom Hatzmaot" - Israel Independence Day, "Yom Yerushalayim" etc. form Hebevents Add On, or chenge the name of it to Israelievents. The "Hebevents" AddOn should only have Jewish events like "Rosh Chodesh", "Purim", "Pesach" and so on
Is this review helpful?
Yes
No
Profile Picture
A User of Hebrew Date Converter
January 31, 2017
Works great! If I may ask, why not add a convertor for the other way around, from a Hebew date to a Gregorian one?
Is this review helpful?
Yes
No
Profile Picture
A User of Hebrew Date Converter
December 26, 2017
I would love to get in touch with the writer of the AddOn to see if you can help me with a one off request for a project where I really need a big static list of date conversions since 1940's.
Is this review helpful?
Yes
No
Profile Picture
Menachem Kantor
July 3, 2016
works great would like to know if it can output in Hebrew?
Is this review helpful?
Yes
No
1-10 of 10
Search
Clear search
Close search
Google apps
Main menu