Julian Date

[Luis Felipe Alcantara]

Hi,

How change a julian date to "normal" date ?

Tks advance,
Luis Felipe

 

[Chip Pearson]

See http://www.cpearson.com/excel/jdates.htm for details.

 

[Guest]

Try this:

For a Julian date in A1.
Example: A1: 06127

B1: =("1/1/"&LEFT(A1,2))+RIGHT(A1,3)-1
In that example, B1 returns 38844 (May 7th, 2006)

Note: Excel will engage it's default year logic in that formula to determine
which century is used. 1900's vs 2000's

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

One more thing:
If your Julian dates are numeric, Excel removes the leading zero.

06127 would become 6127

You can correct for that situation with this formula:

B1: =("1/1/"&INT(A1/1000))+RIGHT(A1,3)-1

***********
Regards,
Ron

XL2002, WinXP-Pro