Dates are numbers in Excel. To obtain a date 7 days earlier, it's just
=Order!E4-7

Tyro

wrote in message
...
I am using Excel 2007 for generating purchase orders. The shipping
date from the vendor needs to be 7 days prior to the shipping date to
the customer. The customer's shipping date is in Order! E4. Can
anybody help me with the formula which will automatically look at the
shipping date in Order! E4, subtract 7 days, then put the new date in
the desired cell? Your help is greatly appreciated. Thank you.