Thread: date format
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
newyorkjoy newyorkjoy is offline
external usenet poster
 
Posts: 38
Default date format

Thank you Rick, but I will not be needing it any more. I appreciate your help.
--
newyorkjoy
thanks for the help!


"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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)" wrote:

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


"newyorkjoy" wrote in message
...
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?
--
newyorkjoy
thanks for the help!