[[email protected]]

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

[Max]

Assuming your initial dates in A2 down are real dates
think you could try in F2:
=DATE(YEAR(A2),MONTH(A2)+B2+C2,DAY(A2)+D2+E2)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
wrote in message
...
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

[Teethless mama]

=EDATE(A2,B2+C2)+D2+E2


" wrote:

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