N
newyorkjoy
Is there any way I can have the date format for the Hebrew Date? Or does
anyone have a column of hebrew dates that I can use?
anyone have a column of hebrew dates that I can use?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein \(MVP - VB\)
I'm not completely sure what you are asking for, but Hebrew to Gregorian (or
vice versa) conversions are not built-in to Excel. I did a quick search and
found this site which offers code that purports to do the conversion
calculations; perhaps you can make use of it...
http://www.geocities.com/DafAWeek/HebCalVb6.html
Rick
vice versa) conversions are not built-in to Excel. I did a quick search and
found this site which offers code that purports to do the conversion
calculations; perhaps you can make use of it...
http://www.geocities.com/DafAWeek/HebCalVb6.html
Rick
N
newyorkjoy
Thank you, but I really do not need any conversions, I just need to put in
the Hebrew date in a cell, and then copy down plus 1 and get s many dates in
the future that I need. (Just as can be done with the Gregorian date.)That's
why I asked if anyone has an excel column with the Hebrew dates that they can
send me, I would be able to use it. (going to the future for at least a
year.)
--
newyorkjoy
thanks for the help!
the Hebrew date in a cell, and then copy down plus 1 and get s many dates in
the future that I need. (Just as can be done with the Gregorian date.)That's
why I asked if anyone has an excel column with the Hebrew dates that they can
send me, I would be able to use it. (going to the future for at least a
year.)
--
newyorkjoy
thanks for the help!
Rick Rothstein (MVP - VB) said:I'm not completely sure what you are asking for, but Hebrew to Gregorian (or
vice versa) conversions are not built-in to Excel. I did a quick search and
found this site which offers code that purports to do the conversion
calculations; perhaps you can make use of it...
http://www.geocities.com/DafAWeek/HebCalVb6.html
Rick
R
Rick Rothstein \(MVP - VB\)
As I said, I don't know of anything built in that will handle Hebrew dates,
but we should be able to create a UDF to add a number of days (1 or more) to
a given Hebrew date using the functions at the link I posted. What format
would you be entering the Hebrew dates into the worksheet in (show an
example please)?
Rick
but we should be able to create a UDF to add a number of days (1 or more) to
a given Hebrew date using the functions at the link I posted. What format
would you be entering the Hebrew dates into the worksheet in (show an
example please)?
Rick
newyorkjoy said:Thank you, but I really do not need any conversions, I just need to put
in
the Hebrew date in a cell, and then copy down plus 1 and get s many dates
in
the future that I need. (Just as can be done with the Gregorian
date.)That's
why I asked if anyone has an excel column with the Hebrew dates that they
can
send me, I would be able to use it. (going to the future for at least a
year.)
N
newyorkjoy
Thank you Rick, but I will not be needing it any more. I appreciate your help.