Formula help needed
 

The reply I received suggested this formula...
=IF(COUNT(C1:D1),MAX(C1+90,D1+60),"")
Many thanks and I carefully tried it but did not completely work.
Maybe I confused the issue...
In column C, if there is a date in C1 or C2 or C3 or C4 and on down say thru
C30, I wish to add 90 days & have the date put in the corresponding E cell,
ie C20 answer in E20.

In column D, if there is a date in D1 or D2 or D3 or D4 and on down say thru
D30, I wish to add 60 days & have the date put in the corresponding E cell.

There would not be a date in C1 and D1 at the same time.
MANY MANY thanks for your help
David
This is a spreadsheet where we would enter a date in either C Or D column
vertically and have it automatically calculate the forward date in E column.

Formula help needed
 

hi
try this one..
=IF(C10,C1+90,IF(D10,D1+60,""))

regards
FSt1

"caseysmydog" wrote:


The reply I received suggested this formula...
=IF(COUNT(C1:D1),MAX(C1+90,D1+60),"")
Many thanks and I carefully tried it but did not completely work.
Maybe I confused the issue...
In column C, if there is a date in C1 or C2 or C3 or C4 and on down say thru
C30, I wish to add 90 days & have the date put in the corresponding E cell,
ie C20 answer in E20.

In column D, if there is a date in D1 or D2 or D3 or D4 and on down say thru
D30, I wish to add 60 days & have the date put in the corresponding E cell.

There would not be a date in C1 and D1 at the same time.
MANY MANY thanks for your help
David
This is a spreadsheet where we would enter a date in either C Or D column
vertically and have it automatically calculate the forward date in E column.

Formula help needed
 

I carefully tried it but did not completely work.

Can you explain what "did not completely work" means?

What results do you expect with these dates:

................C.................D............... E.....
1......1/1/2008.....................................
2.........................2/27/2008................
3.....3/13/2008....................................

Based on your explanation the formula returns these results:

E1 = 3/31/2008 (C1+90)
E2 = 4/27/2008 (D2+60)
E3 = 6/11/2008 (C3+90)


--
Biff
Microsoft Excel MVP


"caseysmydog" wrote in message
...

The reply I received suggested this formula...
=IF(COUNT(C1:D1),MAX(C1+90,D1+60),"")
Many thanks and I carefully tried it but did not completely work.
Maybe I confused the issue...
In column C, if there is a date in C1 or C2 or C3 or C4 and on down say
thru
C30, I wish to add 90 days & have the date put in the corresponding E
cell,
ie C20 answer in E20.

In column D, if there is a date in D1 or D2 or D3 or D4 and on down say
thru
D30, I wish to add 60 days & have the date put in the corresponding E
cell.

There would not be a date in C1 and D1 at the same time.
MANY MANY thanks for your help
David
This is a spreadsheet where we would enter a date in either C Or D column
vertically and have it automatically calculate the forward date in E
column.