| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula dates
Hello
I have the following scenario: Date ColA ColB ColC NewDate 1/3/2001 3 4 10 FORMULA CELL 2/15/2008 4 4 4 FORMULA CELL If a number is 3 then it's equivalent to two years. If it's 4, it means 5 years and if it's 10, it is 15 years. I need to then take the Date column and subtract ColA, ColB and ColC to give a date in the NewDate field. -- Sheldon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a formula that has to do with dates. | Excel Worksheet Functions | |||
| Dates formula | Excel Worksheet Functions | |||
| formula to add dates. | Excel Worksheet Functions | |||
| Need a Formula for DATES | Excel Worksheet Functions | |||
| formula for dates | Excel Discussion (Misc queries) | |||
Threaded Mode
