IF, AND combinations

M

max.harmstorf

Good day to everybody,
I am pretty sure, that someone already asked my question, but I read
so many threads already that I'm totally stuck and confused by now.

I got an intial date and like to add individual month and days, like
this below.
(I know the final dates in F are not correct at the moment, just an
example)

Month Days
A B C D E F
13-04-2007 96 60 12-02-2015
14-11-2007 96 60 15-09-2015
08-09-2005 60 45 25-07-2010
12-08-2004 60 45 12-08-2009

Colum A = my initial date
Colum B = month to be added
Colum C = month to be added
Colum D = day to be added
Colum E = day to be added

IF there are entries in B and D, it should be A+B+D
IF there are entries in B and E, it should be A+B+E
IF there are entries in C and D, it should be A+C+D
IF there are entries in C and E, it should be A+C+E

I know it sounds strage, but I'll need it like that.
I made some approaches, but I didn't really figure out, how the IF/AND
combination works.

Every help is appreciated.

Thanks a lot

Regards
Max
 

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