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

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

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

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

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

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