# Help with Nested IF formulas

#### arcowens

##### New Member
Hello. I work as an academic advisor and unfortunately our student database isn't very robust so we have to verify graduation eligibility by hand (yes, I know, my University is archaic). I've been trying to create a formula in excel to automatically calculate for me what year a student is eligible to walk.

Cell B13 is a date field and will identify the students last date of class. I would like for a formula to say:

IF B13 is >= 9/1/2015 AND B13 is <= 8/31/2016 they'd commence in 2016 OR
IF B13 is >= 9/1/2016 AND B13 is <= 8/31/2017 they'd commence in 2017 OR
IF B13 is >= 9/1/2017 AND B13 is <= 8/31/2018 they'd commence in 2018 OR
IF B13 is >= 9/1/2018 AND B13 is <= 8/31/2019 they'd commence in 2019

This is the formula I've been trying and it doesn't seem to work:
=If(And(M13>=9/1/2014,M13<=8/30/2015),"2015",if(And(M13>=9/1/2015,M13<=8/30/2016),"2016”,if(And(M13>=9/1/2016,M13<=8/30/2017),"2017”,if(And(M13>=9/1/2017,M13<=8/30/2018),"2018”
=If(And(M13>=9/1/2014,M13<=8/30/2015),"2015",if(And(M13>=9/1/2015,M13<=8/30/2016),"2016”,if(And(M13>=9/1/2016,M13<=8/30/2017),"2017”,if(And(M13>=9/1/2017,M13<=8/30/2018),"2018”

Does anyone have any suggestions? I've been scouring the internet reading articles on these statements and I can't quite figure out what I'm doing wrong. I'd appreciate any suggestions . Thanks so much!

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Welcome to the board. Try:

=LOOKUP(M13,{42248,42614,42979,43344,43709},{2016,2017,2018,2019,2020})

Hi

Try:-
Excel Workbook
BC
1301/09/20152016
1431/08/20162016
1501/09/20162017
1631/08/20172017
1701/09/20172018
1831/08/20182018
1901/09/20182019
2031/08/20192019
Arcowens
Excel 2007
Cell Formulas
RangeFormula
C13=YEAR(B13)+(MONTH(B13)>8)

hth

Hi

Try:-
Arcowens
BC
1301/09/20152016
1431/08/20162016
1501/09/20162017
1631/08/20172017
1701/09/20172018
1831/08/20182018
1901/09/20182019
2031/08/20192019

</tbody>
Excel 2007

Worksheet Formulas
CellFormula
C13=YEAR(B13)+(MONTH(B13)>8)

</tbody>

<tbody>
</tbody>

hth

That's a clever solution.

You guys are great - thanks so much!

Replies
6
Views
407
Replies
4
Views
258
Replies
2
Views
230
Replies
4
Views
321
Replies
2
Views
296

1,203,047
Messages
6,053,196
Members
444,645
Latest member
mee siam

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back