Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a julian gregorian date code into a regular date
how do I convert a julian gregorian date code into a regular date. I have a
julian gregorian (1582) date code that I want to convert into a regular month/day/year code. How do I do this? Is there a formula for this? Here is a sample date code: 2453523. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a julian gregorian date code into a regular date
Start with Chip Pearson's website and post back if you have more questions:
http://www.cpearson.com/excel/jdates.htm Does that help? *********** Regards, Ron XL2002, WinXP "Robert" wrote: how do I convert a julian gregorian date code into a regular date. I have a julian gregorian (1582) date code that I want to convert into a regular month/day/year code. How do I do this? Is there a formula for this? Here is a sample date code: 2453523. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a julian gregorian date code into a regular date
On Tue, 13 Jun 2006 09:14:02 -0700, Robert
wrote: how do I convert a julian gregorian date code into a regular date. I have a julian gregorian (1582) date code that I want to convert into a regular month/day/year code. How do I do this? Is there a formula for this? Here is a sample date code: 2453523. It would be helpful for me if you can define exactly what you mean by a "julian gregorian date code" and give some examples of this code and what you expect for a "regular date" A proper Julian Date is an astronomical term. It is defined as a serial number equal to the number of days elapsed since January 1, 4713 B.C., proposed by Joseph Scaliger in 1582 and used in astronomical calculations: January 1, 1965, at noon, Greenwich Civil Time, was Julian Day 2,438,762.0. Some on this NG use the term to stand for one or more digits which stand for the current year, followed by the number of days elapsed in that year. But that doesn't make sense for your example 2453523. That latter would be 1 Jun 2005 12 Noon. 1582, using the astronomical definition, would be 1 May 4709 BCE 12 Noon. So which do you mean? --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a julian gregorian date code into a regular date
On Tue, 13 Jun 2006 09:14:02 -0700, Robert
wrote: how do I convert a julian gregorian date code into a regular date. I have a julian gregorian (1582) date code that I want to convert into a regular month/day/year code. How do I do this? Is there a formula for this? Here is a sample date code: 2453523. OK, now I've got it. You are, in fact, interested in the astronomical calculations. The 1582 finally clued me in :-). For dates on and after March 1, 1900, you can use the formula: = A1 + 2415018.5 to convert a date/time string in A1 to its Julian equivalent. To convert the Julian Date to its Gregorian equivalent, you can use the formula: =A1-2415018.5 If you require a greater range, you will require complex formulas or VBA. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XLS to CSV Conversion - #'s convert to Date | Excel Discussion (Misc queries) | |||
converting julian day and year to a date? | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |