The Hebrew calendar, inside your spreadsheet
Our first add-on, Hebrew Dates, converts dates, shows holidays and the weekly parasha, and fills a whole column with one formula.
Coming soon to the Google Workspace Marketplace.
| A | B | C | |
|---|---|---|---|
| 1 | Date | Hebrew date | Events |
Built for accuracy
A wrong Hebrew date means a reminder that never went out, a payment made early, or an event on the wrong day. So every part is checked before it ships.
219,510 days checked
Every day from 1700 to 2300 was compared with an established open-source calendar, in both directions. No differences were found.
62,722 Shabbatot checked
The weekly parasha and every holiday across 600 years, for Israel and for abroad. No differences were found.
Your data stays in the sheet
Every calculation happens inside your spreadsheet. The add-on sends nothing anywhere and reads nothing beyond the open sheet.
How it works
Install it
Add it from the Google Workspace Marketplace in a few clicks. There is nothing to set up.
Type a formula
In any cell, type
=HEBREW_DATE(A2)and the Hebrew date appears right away, in Hebrew letters or in English.Fill a whole column
Give a range instead of one cell, such as
=HEBREW_DATE(A2:A500), and the whole column fills at once.
Hebrew Dates for Google Sheets
Three formulas: the Hebrew date for any date, conversion back to a regular date, and holidays and the weekly parasha for any day. In Hebrew or English, for Israel or abroad.