| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with dates
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Threaded Mode
