Hi,
I am facing a problem in converting Gregorian date in to a Jewish date.
Everything works fine as long as sheet formulas are concerned (see attached picture)
Upon trying the same in VBA it seems as the [$-88099] Format is useless.
I need to retrieve the 3 values (like in cells: C7, C10, C13 into 3 variables: DD, MM, YY.
Any help will be more than appreciated.
Thanks,
Elm
(Excel 2013, Windows 8.1)
NONAME.png
Bookmarks