Formula Help
 

i have about 4 date cells. in 3 of the cell a date has to be entered but
depending on which cell the date is entered the due date will be diffrent.

|-------------------------------------------------------|
| cell1 | cell2 | cell3 | cell4 | cell5 | due date |
|-------------------------------------------------------|
| 90day|1year|2year|30day|60day| due date |
|-------------------------------------------------------|
| 90day|1year|2year|30day|60day| due date |

so the due date in column 4 will differ depending on which cell is filled in
the row.....?You will have to tell us how to calculate the due date or where
we can look for it!
--
paul
remove nospam for email addy!



"Kenny Dee" wrote:

i have about 4 date cells. in 3 of the cell a date has to be entered but
depending on which cell the date is entered the due date will be diffrent.

|-------------------------------------------------------|
| cell1 | cell2 | cell3 | cell4 | cell5 | due date |
|-------------------------------------------------------|
| 90day|1year|2year|30day|60day| due date |
|-------------------------------------------------------|
| 90day|1year|2year|30day|60day| due date |

Yes. The # of days are noted in the cells that i drew up. Does that help?

"paul" wrote:

so the due date in column 4 will differ depending on which cell is filled in
the row.....?You will have to tell us how to calculate the due date or where
we can look for it!
--
paul
remove nospam for email addy!



"Kenny Dee" wrote:

i have about 4 date cells. in 3 of the cell a date has to be entered but
depending on which cell the date is entered the due date will be diffrent.

|-------------------------------------------------------|
| cell1 | cell2 | cell3 | cell4 | cell5 | due date |
|-------------------------------------------------------|
| 90day|1year|2year|30day|60day| due date |
|-------------------------------------------------------|
| 90day|1year|2year|30day|60day| due date |