LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
aftamath
 
Posts: n/a
Default 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


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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dragging formula linked to diff sheets Chrism Excel Discussion (Misc queries) 2 September 10th 05 11:48 AM
Can someone help with a formula to calculate dates? SharonP. Excel Discussion (Misc queries) 11 August 9th 05 01:47 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
How do I format dates accessed by a formula Mont22 Excel Discussion (Misc queries) 2 January 12th 05 04:09 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"