Hi,
Please explain the 108001 date to us so we can help figure out what you
need. Where does the 80 come from? 10 is 2010? and 01 is 1?
Cheers,
Shane Devenshire
"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