Essentially, I need to do the following:

IF <RANK> is E1, then the value of the column is <PEBD> + 6 YEARS

OR

IF <RANK> is E2, then the value of the column is <PEBD> + 6 YEARS

OR

IF <RANK> is E3, then the value of the column is <PEBD> + 10 YEARS

I need to do this all the way until E9.

Here is what I came up with, which is apparently a legitimate formula, but only returns a value of "1" if the conditions are met:

Code:

`=OR(IF([Rank]="E1",DATE(YEAR([PEBD])+6,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E2",DATE(YEAR([PEBD])+6,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E3",DATE(YEAR([PEBD])+10,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E4",DATE(YEAR([PEBD])+12,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E5",DATE(YEAR([PEBD])+20,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E6",DATE(YEAR([PEBD])+22,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E7",DATE(YEAR([PEBD])+24,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E8",DATE(YEAR([PEBD])+26,MONTH([PEBD])+0,DAY([PEBD])-1)),IF([Rank]="E9",DATE(YEAR([PEBD])+30,MONTH([PEBD])+0,DAY([PEBD])-1)))`