| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate a date based on values in other cell, worksheet
I have a worksheet (Inventory) that contains colums for PartID, Category,
DateMade and DateToRecyle. I also have another sheet (RetainPeriod) in the Workbook that has Category and RetentionPeriod. In Inventory when someone enters the PartID, Category, and DateMade. I want to calculate the DatetoRecycle based on the Category and its associated RetentionPeriod (in months) from worksheet RetainPeriod. I know it's probably a VLookup but I don't know how to formulate the function. Help is appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing values in cell based on system date | Excel Worksheet Functions | |||
| On opening a worksheet move focus to a cell based on date | Excel Worksheet Functions | |||
| Calculate sum of values based on a ref value, how? | Excel Discussion (Misc queries) | |||
| IF statement to calculate based on cell values | Excel Worksheet Functions | |||
| if cell has date value how to calculate other cell values | Excel Discussion (Misc queries) | |||
Threaded Mode
