Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|