Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! -- saltrm ------------------------------------------------------------------------ saltrm's Profile: http://www.excelforum.com/member.php...o&userid=28624 View this thread: http://www.excelforum.com/showthread...hreadid=482869 |
#2
|
|||
|
|||
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!! -- saltrm ------------------------------------------------------------------------ saltrm's Profile: http://www.excelforum.com/member.php...o&userid=28624 View this thread: http://www.excelforum.com/showthread...hreadid=482869 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for calc diff between two julian dates | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Date Calc. HELP | New Users to Excel | |||
convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) |