Closed Thread
Results 1 to 12 of 12

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,855

    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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

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

    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,855

    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


  11. #11
    Registered User
    Join Date
    07-20-2020
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Hebrew (jewish) dates

    Hi,

    Sorry for bringing up an old thread, but how exactly did you get the Hebrew month with that formula? I got the correct Hebrew date but with the month in Gregorian
    Attachment 812071

    Thanks

  12. #12
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Hebrew (jewish) dates

    @123szk

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Closed 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. [SOLVED] 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