1. General
  2. Ideas
0
Completed

i am attempting to set up a Hebrew calendar in columns in Excel.

Julius Ronquest 4 years ago • updated by Mal Sokol 10 months ago • 2

I want to use the spreadsheet to record Hebrew history and current events. I have started with Metonic cycle 304 but it is taking me forever. Will you be able to assist me in setting up such a columnar spreadsheet containing all your calendar data? I am planning to eventually include all the cycles in this spreadsheet. Your help will be greatly appreciated.

Completed
Michael J. Radwin 2 years ago

An internet search turns up HebCalVb6, a VB6/VBA module to demonstrate how to convert a Hebrew date into the Gregorian date. It can be used within Visual Basic or within a Excel Macro. 

http://www.dafaweek.com/HebCal/HebCalVb6.php

Mal Sokol 10 months ago

I used the VBA code in a previous Excel VBA application and it worked but was a lot to maintain.  I would like to use WEBAPIs and use  XMLHTTP calls in the VBA instead.  I am looking for the syntax and I think the Greg to Heb and reverse calls are obvious.   But I am looking for a call that is the functional equivalent of IsLeap in the VBA to determine if a Hebrew Year is or isn't a leap year without some complex code to figure out if Adar II is i the current year.

Customer support service by UserEcho