software

I need the formula to convert numbers to a standard date format. Some
examples are as follows: 16330
22364
19215
19206
24273
17030
24277
20240
27289
21183
26284
27246www.cpearson.com/excel/jdates.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;tamtec99quot; gt; wrote in message
...
gt;I need the formula to convert numbers to a standard date format. Some
gt; examples are as follows: 16330
gt; 22364
gt; 19215
gt; 19206
gt; 24273
gt; 17030
gt; 24277
gt; 20240
gt; 27289
gt; 21183
gt; 26284
gt; 27246
gt;=?Utf-8?B?dGFtdGVjOTk=?= gt; wrote in
:

gt; I need the formula to convert numbers to a standard date format. Some
gt; examples are as follows: 16330
gt; 22364
gt; 19215
gt; 19206
gt; 24273
gt; 17030
gt; 24277
gt; 20240
gt; 27289
gt; 21183
gt; 26284
gt; 27246
gt;
gt;

Ifound this at www.cpearson.com/excel/jdates.htm

Converting A Julian Date To A Standard Date

The formula below will convert a Julian date to a standard Excel date.

=DATE(IF(0 (LEFT(A1,2))lt;30,2000,1900) LEFT(A1,2),1 ,RIGHT(A1,3))

If the year digits of the Julian date are less than 30 (i.e., 00 to 29),
the date is assumed to be a 2000 century year. If the year digits of
the Julian date are greater than or equal to 30 (i.e., 30 to 99), the
date is assumed to be a 1900 century year. This formula works by taking
advantage of the fact that the DATE function can handle days beyond the
quot;normalquot; days in a month. For example, DATE correctly computes 100-Jan-
1999 to be 10-April-1999.

These Julian dates must have the leading zero or zeros for years between
2000 and 2009. For example the 123rd day of 2000 must be entered as
00123. Format the cell as TEXT before entering the data, or enter an
apostrophe before the Julian date -- e.g., '00123. This will prevent
Excel from treating the Julian date as a number and suppressing the
leading zeros.