Was there any special reason for using
+(-(INT(A1/1000)*1000)+A1)
rather than
+MOD(A1,1000) ?
--
David Biddulph

AnotherNewGuy wrote:
=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