HDATE_HEB Function (Gnumeric)

HDATE_HEB([year], [month], [day])

The arguments are a Gregorian year, Gregorian month, and Gregorian day, despite the Hebrew-script output. Use a full year and integer components. Each omitted component defaults to the current corresponding date component in the running process; explicitly supplying all three avoids date-dependent reports.

The result is a string. It is not a number that can be incremented to obtain tomorrow, and changing the result cell’s number format does not convert it into a date serial. Retain the original Gregorian date for sorting, filtering, intervals, and comparisons.

The following native outputs preserve Gnumeric’s Unicode text, including Hebrew punctuation and combining marks:

The first date corresponds to 6 Nisan 5761, and the second to 1 Tishri 5784. Those Latin-script descriptions are explanations, not alternative exact outputs of HDATE_HEB.

For a table with year, month, and day in A2:C2, use =HDATE_HEB(A2,B2,C2) and copy it down alongside the source components. Review an exported file to confirm that the receiving program preserves the Hebrew characters.

Keep a numeric Gregorian date column as the authoritative chronological field and a separate Hebrew label column for presentation. A bilingual report can display both without trying to recover calendar components by parsing a styled string.

The output contains combining marks. Visual appearance, character counts, and copying through older encodings can be surprising. A font with Hebrew support and an appropriate text direction may improve presentation, but do not reverse the string manually to imitate how it should look on screen. The stored character order and the displayed bidirectional layout are different concerns.

The native evidence here verifies returned text, not a screenshot or every font/export combination. Check the final delivery format before distributing a document that depends on exact rendering.

=HDATE_HEB(2023,13,1) returns #VALUE!. However, the component converter does not enforce all month-specific day limits: =HDATE_HEB(2023,2,31) produces a Hebrew label corresponding to 10 Adar 5783. Validate civil dates before conversion; successful output is not a calendar-validity test.

If the label is stale in a saved report, check whether the formula omitted date components and whether recalculation occurred. For an archival record, explicit dates are preferable to current-date defaults. The function is registered as volatile.

There is no time, place, or sunset input. Do not use this display conversion by itself to decide a location-dependent religious-day boundary or event time. Also do not supply Hebrew calendar components as if the function were converting in the opposite direction.

Hebrew-calendar functions appear in the Gnumeric 1.9.15 release notes, and that release’s source includes HDATE_HEB. This guide is scoped to 1.12.57. The two valid dates and two invalid-component cases were recalculated under C.UTF-8 on 17 October 2026. Output strings are native evidence; GUI rendering is untested. No retirement or complete historical-version guarantee is claimed.

DATE stores a Gregorian date, and YEAR, MONTH, and DAY extract its components for a display column.

• Gnumeric 1.12.57 help and implementation
• Gnumeric function catalog
• Gnumeric release history through 1.12.57
• Gnumeric 1.9.15 Hebrew-calendar registration