Using this formula, you can convert the Gregorian date in a given cell to a Hebrew date
=IMPORTXML(CONCATENATE("https://www.hebcal.com/converter?cfg=xml&date=",TEXT(A2, "yyyy-mm-dd"),"&g2h=1&strict=1"), "//hebrew/@str")
Customer support service by UserEcho
Using this formula, you can convert the Gregorian date in a given cell to a Hebrew date
=IMPORTXML(CONCATENATE("https://www.hebcal.com/converter?cfg=xml&date=",TEXT(A2, "yyyy-mm-dd"),"&g2h=1&strict=1"), "//hebrew/@str")