Because I didn't think of using mod() ;o)

I worked this out two years ago to deal with Julian dates formatted like
2008001. I've learned a lot since then, primarily from this forum. It
turned out the exact formula worked for dates formatted like 108001.

thx for the suggestion. I'll change my example sheet.

"David Biddulph" wrote:

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