Julian Date

[A]

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

 

[Tyro]

See the following for converting a Gregorian date to Julian:
http://www.cpearson.com/excel/jdates.htm

Tyro

 

[Kevin B]

The following example assumes that the gregorian date is in cell A1

=A3-DATE(YEAR(A3),1,0))

 

[Tyro]

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]

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#")

 

[Tyro]

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