View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default convert Julian date to DD/MM/YYYY

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