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...
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!
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...
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
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.)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
