Calc Diff Between Two Julian Date
 

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!!

:confused:


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

Calc Diff Between Two Julian Date
 

=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!!

:confused:


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

Calc Diff Between Two Julian Date
 

I got a value of "34391" when I applied the formula. Maybe I did
something wrong when applying?


=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)))

That the what I used

MY spreadsheet looks like this

J-2 K-2 L-2
4350 5310 Should read "325"


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

Calc Diff Between Two Julian Date
 

I get 326

--

HTH

RP
(remove nothere from the email address if mailing direct)


"saltrm" wrote in
message ...

I got a value of "34391" when I applied the formula. Maybe I did
something wrong when applying?


=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)))

That the what I used

MY spreadsheet looks like this

J-2 K-2 L-2
4350 5310 Should read "325"


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

Calc Diff Between Two Julian Date
 

How about:

=DATE((2000+INT(K2/1000)),0,MOD(K2,1000))
- DATE((2000+INT(J2/1000)),0,MOD(J2,1000))
+ 1

(all one cell.)

Just a tip.

It's better to give a small sample of your data in your initial post. It makes
things easier for possible responders.

saltrm wrote:

I got a value of "34391" when I applied the formula. Maybe I did
something wrong when applying?

=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)))

That the what I used

MY spreadsheet looks like this

J-2 K-2 L-2
4350 5310 Should read "325"

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

--

Dave Peterson

Calc Diff Between Two Julian Date
 

Got it to work! Thanks Dave and Bob for both of your help.

Ron Saltzman :)


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