If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Julian Date
I need laymen terms for help - I am not a programmer... I have a date in a
column and need to make it a julian date. IE: 12/31/07 to 365 Working with Excel 03 |
#2
|
|||
|
|||
Julian Date
See the following for converting a Gregorian date to Julian:
http://www.cpearson.com/excel/jdates.htm Tyro "A" wrote in message ... I need laymen terms for help - I am not a programmer... I have a date in a column and need to make it a julian date. IE: 12/31/07 to 365 Working with Excel 03 |
#3
|
|||
|
|||
Julian Date
The following example assumes that the gregorian date is in cell A1
=A3-DATE(YEAR(A3),1,0)) -- Kevin Backmann "A" wrote: I need laymen terms for help - I am not a programmer... I have a date in a column and need to make it a julian date. IE: 12/31/07 to 365 Working with Excel 03 |
#4
|
|||
|
|||
Julian Date
Say what?
In the United States. the Julian date for January 9, 2008 is: 08009. The Julian date consists of year, day of year. The year could be 1,2 or 4 numbers wide. i.e; 8009, 08009 or 0008009. How does your formula produce that? Tyro "Kevin B" wrote in message ... The following example assumes that the gregorian date is in cell A1 =A3-DATE(YEAR(A3),1,0)) -- Kevin Backmann "A" wrote: I need laymen terms for help - I am not a programmer... I have a date in a column and need to make it a julian date. IE: 12/31/07 to 365 Working with Excel 03 |
#5
|
|||
|
|||
Julian Date
Sorry, I gave you the Julian day formula, the following is the formula I
meant to send: =RIGHT(TEXT(YEAR(A1),"####"),2)&TEXT((A1-DATE(YEAR(A1),1,0)),"00#") -- Kevin Backmann "Tyro" wrote: Say what? In the United States. the Julian date for January 9, 2008 is: 08009. The Julian date consists of year, day of year. The year could be 1,2 or 4 numbers wide. i.e; 8009, 08009 or 0008009. How does your formula produce that? Tyro "Kevin B" wrote in message ... The following example assumes that the gregorian date is in cell A1 =A3-DATE(YEAR(A3),1,0)) -- Kevin Backmann "A" wrote: I need laymen terms for help - I am not a programmer... I have a date in a column and need to make it a julian date. IE: 12/31/07 to 365 Working with Excel 03 |
#6
|
|||
|
|||
Julian Date
If you want the Julian date left justified as text, enter:
=RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000") If you want the Julian date right justified as a number enter: =--(RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000")) Tyro "A" wrote in message ... I need laymen terms for help - I am not a programmer... I have a date in a column and need to make it a julian date. IE: 12/31/07 to 365 Working with Excel 03 |
Thread Tools | |
Display Modes | |
|
|