Help wit a formula

C

caseysmydog

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top