=DATE(INT(A1/1000)-1,12,31)+(-(INT(A1/1000)*1000)+A1)

The above seems to work for me. Excel seems to assume the first three
digits should be added to 1900.

"Raj" wrote:

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