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/