|
| 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
January 9th, 2008, 08:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
January 9th, 2008, 08:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
January 9th, 2008, 08:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
January 9th, 2008, 09:14 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
January 9th, 2008, 09:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
January 9th, 2008, 10:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
