Hi Deepak,

Let me just give you some example

Julian Date = 104001 dd/mm/yyyy = 01/01/2004
1 is century, 04 is year and 001 is day i.e. 1st
104002 will become 02/01/2004

But Julian Date = 99001 dd/mm/yyyy = 01/01/1999

In excel there is a direct formula available which is

In Cell A2 place a Julian date, like 102324

in Cell B2 place this formula: (copy it in)

=DATE(YEAR("01/01/"&TEXT(1900+INT(A2/1000),0)),MONTH("01/01/"&TEXT(1900+INT(A2/1000),0)),DAY("01/01/"&TEXT(1900+INT(A2/1000),0)))+MOD(A2,1000)-1

The date 11/20/02 date will appear in cell B2

I hope this will explain you what I need.

Thanks and regrads

Ashish Patel