Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |