+ Reply to Thread
Results 1 to 10 of 10

Hebrew (jewish) dates

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Hebrew (jewish) dates

    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

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Hebrew (jewish) dates

    You may find module written by Scott E. Lee useful.
    http://trigeminal.fmsinc.com/code/He...dGregorian.bas
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Hebrew (jewish) dates

    Quote Originally Posted by CK76 View Post
    You may find module written by Scott E. Lee useful.
    http://trigeminal.fmsinc.com/code/He...dGregorian.bas
    Thanks, CK76,
    I'm familiar with most of the VBA Codes regarding this issue.
    The one you proposed is way to complicated than it should be.
    My question was referring only to the use of the [$-88099] format.
    Any other FORMAT (which produces the same 3 results) will be satisfactory.
    Elm.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,264

    Re: Hebrew (jewish) dates

    Attached is a small Access DB that does the conversion. I know that you are looking for an Excel VBA solution, but I put this out there as an alternative.

    alan
    Attached Files Attached Files

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Hebrew (jewish) dates

    Simple answer, you can't (in VBA alone).

    Just use WorksheetFunction.Text

    Please Login or Register  to view this content.
    Edit: Or use Evaluate
    Please Login or Register  to view this content.
    Last edited by CK76; 05-26-2017 at 09:55 AM. Reason: See Edit:

  6. #6
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Hebrew (jewish) dates

    CK76,
    That was exactly what I was looking for.
    The use of Sheet's functions in VBA is no "sin". :-)
    My mistake was that I have used a wrong date format.
    I used it as a text string.
    Adding the CDate resolved the problem.
    Thanks for your code which lightened my eyes (and opened my mind)
    Have anice weekend,
    Elm

    NONAME.png
    Last edited by ElmerS; 05-26-2017 at 10:39 AM.

  7. #7
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Hebrew (jewish) dates

    Thanks Alan,
    As you can, already, see this is also a "too complicated" code.
    Elm
    Last edited by ElmerS; 05-26-2017 at 10:42 AM.

  8. #8
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Hebrew (jewish) dates

    CK76,
    Where do I mark your answer as [SOLVED] ?
    Elm

  9. #9
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Hebrew (jewish) dates

    I see you figured it out

  10. #10
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Hebrew (jewish) dates


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Jewish / Civil Date Converter
    By BjarneHansen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-23-2016, 07:34 AM
  2. got problem with hebrew
    By dodo134679258 in forum Excel General
    Replies: 0
    Last Post: 10-27-2015, 12:37 PM
  3. Convert Hebrew? Dates to Enghish
    By MarvinP in forum Non English Excel
    Replies: 1
    Last Post: 10-02-2014, 10:27 PM
  4. How to display Hebrew date in Hebrew numberal in Excel.
    By rajkumar.r in forum Excel General
    Replies: 5
    Last Post: 09-04-2013, 05:42 PM
  5. Sort by Hebrew Date
    By Desperate Dan in forum Excel General
    Replies: 1
    Last Post: 11-16-2005, 08:20 PM
  6. Insert Hebrew Date
    By yossele in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2005, 04:05 PM
  7. Excel Autoformats to hebrew!?
    By esfisher in forum Excel General
    Replies: 1
    Last Post: 05-02-2005, 03:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1