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(B2A2,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

On Jan 28, 12:04*pm, "Kelly_Durden" <u41001@uwe wrote:
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

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?

JP wrote:
This formula will show the difference (in days) between two dates.

In C2 enter:

=IF(B2A2,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

--
Message posted via http://www.officekb.com

Mon, 28 Jan 2008 17:04:43 GMT from Kelly_Durden <u41001@uwe:

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Hi

This formula worked!

Thank you!

Stan Brown wrote:
Mon, 28 Jan 2008 17:04:43 GMT from Kelly_Durden <u41001@uwe:

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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200801/1

Tue, 29 Jan 2008 10:06:21 GMT from Kelly_Durden via OfficeKB.com
<u41001@uwe:
Stan Brown wrote:
Mon, 28 Jan 2008 17:04:43 GMT from Kelly_Durden <u41001@uwe:
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.

This formula worked!

Thank you!

You're most welcome! Thanks for the feedback.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/