General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only