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