Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 | |
#2
|
|||
|
|||
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 | |
#3
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |