Formula for looking at 1 cell with a date and then comparing it to four date ranges

[LearningMom]

We have one column with a last date gave. We want to write a formula that looks at that cell and outputs a "0" if it is before 06/30/2014 outputs a "1" if the date in the cell is between 7/1/2014 and 6/30/2015 and then a "2" if it is between 7/1/15 and 6/30/16 and a "3" between 7/1/16 and 6/30/18

Thank you

[LearningMom]

I thought I would show you the formula a have been tweaking with no success. I did get a 1 once but when I added the third formula it stopped with a error message.

=IF(AND(M4955<=DATE(2014,30,6)),0,IF(AND(M4955<=DA TE(2014,1,7),M4955<=DATE(2015,30,6)),1))

[NBVC]

Maybe?

=IF(M4955<=DATE(2014,6,30),0,IF(AND(M4955>=DATE(2014,7,1),M4955<=DATE(2015,6,30)),1,IF(AND(M4955>=DATE(2015,7,1),M4955<=DATE(2016,6,30)),2,IF(AND(M4955>=DATE(2016,7,1),M4955<=DATE(2018,6,30)),3,""))))

[LearningMom]

Thank you, clearly the first AND I didn't think of removing. I am blaming trying way to many ideas and not returning to the original for the multitude of errors.

Thank you again.