| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating for a specific date range
I have a column that lists a date of manufacture for an item. I need the next
colum to tell me the date 6 months before the date of manufacture in 4 years. I then need it to tell me the date for 6 months after the date of manufacture in 8 years. So for example, this units date of manufacture is November of 2003. I need the next column to tell me 5/2007, then for the next 5/2008. Any help? -- Christy P |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| find sum if one col = ? within specific date range | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| How do I sum a date specific range of cells? | Excel Worksheet Functions | |||
Threaded Mode
