=ABS(DATE(INT(J2)/1000+IF(J2<30000,2000,1900),1,MOD(J2,1000)) -DATE(INT(K2)/
1000+IF(K2<30000,2000,1900),1,MOD(K2,1000)))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"saltrm" wrote in
message ...
Need to calculate difference between 2 julian dates. Worksheet is as
follows:
J-2=Date Ordered
K-2=Date Received
L-2=Lag time
Hope someone can help!!
--
saltrm
------------------------------------------------------------------------
saltrm's Profile:
http://www.excelforum.com/member.php...o&userid=28624
View this thread: http://www.excelforum.com/showthread...hreadid=482869