Overdue Delivery Dates

  • Thread starter Thread starter Kelly_Durden
  • Start date Start date
K

Kelly_Durden

Hello,

I have a 118 expected deliveries, the due dates are in column B2:B118. I want
to try to calculate the number of days the delivery are overdue by?

Can someone please help me with a formula for this?

Thanks
Kelly
 
This formula will show the difference (in days) between two dates.

In C2 enter:

=IF(B2>A2,INT(B2)-INT(A2),"")

For example if your due date is in A2:A118 and the actual delivery
date is B2:B118, simply fill this formula down all the way to C118.


HTH,
JP
 
Mon said:
I have a 118 expected deliveries, the due dates are in column B2:B118. I want
to try to calculate the number of days the delivery are overdue by?
Click to expand...

=TODAY()-B2
and propagate to the desired number of rows.
 
Hi, I entered this formula in to C2, but the result was blank. Is there a
certain format I should be using for the date?
This formula will show the difference (in days) between two dates.

In C2 enter:

=IF(B2>A2,INT(B2)-INT(A2),"")

For example if your due date is in A2:A118 and the actual delivery
date is B2:B118, simply fill this formula down all the way to C118.

HTH,
JP
Hello,
Click to expand...
[quoted text clipped - 5 lines]
Thanks
Kelly
Click to expand...
Click to expand...
 
Back
Top