IF, AND combinations
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 |
IF, AND combinations
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 |
IF, AND combinations
=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 |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com