ExcelBanter - Formula for calc diff between two julian dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for calc diff between two julian dates (https://www.excelbanter.com/excel-discussion-misc-queries/54141-formula-calc-diff-between-two-julian-dates.html)

saltrm

Formula for calc diff between two julian dates

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 :confused:

--
saltrm
------------------------------------------------------------------------
saltrm's Profile: http://www.excelforum.com/member.php...o&userid=28624
View this thread: http://www.excelforum.com/showthread...hreadid=482882

aftamath

Formula for calc diff between two julian dates

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 :confused:

--
saltrm
------------------------------------------------------------------------
saltrm's Profile: http://www.excelforum.com/member.php...o&userid=28624
View this thread: http://www.excelforum.com/showthread...hreadid=482882

All times are GMT +1. The time now is 11:51 AM.