<what the coding system of your dates is

Look here to see how many interpretations of "Julian date"there a

http://en.wikipedia.org/wiki/Julian_date

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
108001 is not a Julian date as defined by Chip; it has 6 digits, not 5.
What is the meaning of the first 1?
If you don't need it, drop it and use Chip's formula.
Otherwise, tell us what the coding system of your dates is.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Raj" wrote in message
...
Hi neik
I tried the formula
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1 ,RIGHT(A1,3))
I have the julian date as 108001 has to give 1/1/2008 but it is giving
1/1/2010 can you help me regarding this
"Niek Otten" wrote:

Look he

http://www.cpearson.com/excel/jdates.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Raj" wrote in message
...
Hi
I want to convert Julian Date to DD/MM/YYYY format is there any way we
can
do it in excel