Julian Date

A

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
 
K

Kevin B

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

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

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
 
K

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