EXCEL 2003 Dates & elapsed time

[Guest]

Elegant formula help needed. the 4 cells concerned are:

Date received, Date Claimed, storage start date and Elapsed days. Where: if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If > than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.

This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J5>1,J5+1))

Many thanks

 

[JE McGimpsey]

One way:

If you're only entering dates:

Storage Start Date:

L5: =IF(J5=K5,"",J5+1)

Elapsed Days:

M5: =IF(L5="","",TODAY()-L5)

If you're actually entering dates and times in J5 & K5, then

L5: =IF(K5-J5<=1,"",J5+1)
M5: =IF(L5="","",INT(NOW()-L5))

 

[Guest]

If the dates are DATES only (no times) then try this:

in L5:

=IF(K5-J5<=1,"",J5+1)

Elapsed days: (in M5)

=IF(L5<>"",TODAY()-L5+1,"")

J2=07/04/2007 (UK dates)
K2=12/04/2007
L2=08/04/2007
M2=4 (today is 11/04/2007)

HTH

 

[Guest]

Many thanks. I have since found that I need to 'stop the clock' when a
claimed date (L2) is entered. M2 continues to tot-up elapsed days?

TIA

Dan