View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default Overdue Delivery Dates

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/