Hebrew Dates
Three simple formulas that bring the Hebrew calendar into your sheet: the Hebrew date for any date, conversion back to a regular date, and holidays, fasts, Rosh Chodesh and the weekly parasha for any day.
Coming soon to the Google Workspace Marketplace.
| A | B | C | |
|---|---|---|---|
| 1 | Date | Hebrew date | Events |
The three formulas
Type them in a cell like any other formula. Each one also accepts a whole range.
=HEBREW_DATE(date)
Returns the Hebrew date, such as א׳ תשרי תשפ״ז.
For a time after sunset: =HEBREW_DATE(A2, TRUE)
In English: =HEBREW_DATE(A2, FALSE, "en")
=GREG_DATE(hebrew_date)
Converts a Hebrew date to a regular date. Write it in Hebrew letters, like "ט״ו בשבט תשפ״ז", or in English, like "15 Shevat 5787".
In a leap year, write Adar I or Adar II.
=HEB_EVENTS(date)
Returns the holidays, fasts, Rosh Chodesh, Chanukah and weekly parasha for that day.
The Israel calendar is the default. For abroad: =HEB_EVENTS(A2, "en", FALSE)
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.
For long lists
A whole column in one formula
=HEBREW_DATE(A2:A500)fills the entire column, much faster than copying a formula down row by row.Empty rows stay empty
Set the formula up ahead of time for rows you haven't filled yet, with no error messages.
An error stays in its own row
A bad value shows an explanation in its own row only, and every other row keeps working.