DateDiff("d", "J2", "K2")
"saltrm" wrote:
Looking for the formula for calc diff between two julian dates.
Worksheet is as follows:
J-2 = order date
K-2 = receive date
L-2 = Lag time 
--
saltrm
------------------------------------------------------------------------
saltrm's Profile: http://www.excelforum.com/member.php...o&userid=28624
View this thread: http://www.excelforum.com/showthread...hreadid=482882