S
Sheldon
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.
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.