Help wit a formula
 

Column c may or may not have a date in each cell.
Column d may or may not have a date in each cell.
They will not have a date in corresponding cells at the same time.
If column c has a date then add 90 to that to equal column e
If column d has a date then add 60 to that to get column e.
And on it goes for each cell in each column

C1 D1 E1
3/27/2008 result
4/14/2008 result
C2 D2 E2
4/21/2008 result

Please help...of course column E would convert serial number to date.
MANY THANKS...
caseysmydog

Help wit a formula
 

Try this:

=IF(COUNT(C1:D1),MAX(C1+90,D1+60),"")

Format as DATE


--
Biff
Microsoft Excel MVP


"caseysmydog" wrote in message
...
Column c may or may not have a date in each cell.
Column d may or may not have a date in each cell.
They will not have a date in corresponding cells at the same time.
If column c has a date then add 90 to that to equal column e
If column d has a date then add 60 to that to get column e.
And on it goes for each cell in each column

C1 D1 E1
3/27/2008 result
4/14/2008 result
C2 D2 E2
4/21/2008 result

Please help...of course column E would convert serial number to date.
MANY THANKS...
caseysmydog