excel if then statement

Question

I am trying to create a spreadsheet that will say what year a student must exit school. A student with disabilities must exit by the spring of the school year that they turn 21. So I want a calculation to add one year if they turn 21 between August 25th and December 31st of any given year. Or return the same year if they turn 21 in January through June 8th of any given year.

I might be complicating this too much so feel free to give alternate suggestions.

Answer 1

Assuming A1 cell contains student's birth date, here is the formula:

=YEAR(A1) + IF(OR(AND(MONTH(A1) = 8; DAY(A1) >= 25); MONTH(A1) > 8); 22; 21)

Some caveats:

1. It is not clear from your question what the formula must return for birth dates between June 8th and August 25th. I suppose it's just a typo that this date interval is remain undefined and it should be included either in date interval to add one year or in date interval to not add. So, for certainty I add one year if birth date is between August 25th and December 31st and don't add otherwise.
2. I'm using Russian version of Excel and all function names are in Russian here. I translated them manually to English. But I have no chance to check it in English version. So, I can't guarantee that my formula is 100% working but I hope it is.

P.S. If this formula won't work for you feel free to comment on my answer and I'll try to correct it.