Overdue Delivery Dates

[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

 

[JP]

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

 

[Stan Brown]

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?

=TODAY()-B2
and propagate to the desired number of rows.

 

[Kelly_Durden via OfficeKB.com]

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,

[quoted text clipped - 5 lines]

Thanks
Kelly

 

[Kelly_Durden via OfficeKB.com]

Hi

This formula worked!

Thank you!

=TODAY()-B2
and propagate to the desired number of rows.

 

[Stan Brown]

Tue, 29 Jan 2008 10:06:21 GMT from Kelly_Durden via OfficeKB.com

This formula worked!

Thank you!

You're most welcome! Thanks for the feedback.